Convert the text time field into time8.

[zimcom]

Hi all,

How can I convert the time_1, time_2 and time_3 into time8. format?

SUBJECT	time_1	time_2	time_3
117961	18:49	19:02	19:20
118036	15:03	15:35	15:50
118066	19:40	20:10	20:15
118118	0:04	0:25	0:49
118151	23:06	23:30	23:40
118377	9:18	9:39
118682	14:39	15:06
118730	12:45	13:04	13:22
118872	18:00	18:23	18:49
118874	16:11	16:18	16:56
118875	15:52	16:15	16:27
119054	23:51	0:06	0:18
119121	15:04	15:15	15:34
119495	11:42	12:13	12:25
119555	13:00	12:59	13:11
119621	18:32	18:48	19:05
119651	8:20	8:41

[Reeza · Accepted solution]

Time_num = input(time, hhmmss. );

fornat time_num time.;

[zimcom]

Thank you, Reeza