From your description you must mean that your time data looks like
1 20;05 22;40
2 . .
3 2;15 6;40
1 20:05 22:40
2 . .
3 2:15 6:40
I can think of a couple of ways to do this and there may be others. One
method is to read the times in as STRINGs, extract the hours and minutes as
separate numeric variables and then recombine them into a time value. The
other method is to again read the data in as STRINGs, do a locate and
replace of the semicolin with a colon, write the data back out to a text
file and then read that file back in using time formats. I think there's
more opportunities for cleverness, if that appeals to you, in the first
method. It's Friday, so I'll do the second method. I'll assume that you can
set up the Data list statement or text data wizard to get the data in.
Then, (let T1 and T2 be the two time variables as read and T1m and T2m be
the modified values.
Do repeat x=T1 T2/y=T1m T2m.
+ Compute #loc=index(x,';').
+ Compute substr(x,#loc,1)=':'.
I'll assume you can set up the syntax to write out the corrected variables
(plus any others).
The first syntax was too convoluted .
If t1 and t2 and the original 2 time variables, you can convert
you data to the required format using the syntax below.
You can then proceed to use Raynald's syntax.