Time Conversion

[gnrslasher37]

hi,

i have numeric data in hundreths place like

250

103

356

 which i want to convert it in the Time format of hhmm.

Thanks.

[RahulG]

What is your desired output.

do you want to see your data as mentioned below

02:50

01:03

03:56

[Tom · Accepted solution]

You could just use some arithmetic and the HMS() function.

time=hms(int(number/100),mod(number,100),0);

Or you could add some leading and trailing zeros to make it look like HHMMSS string and use the INPUT() function.

time=input(put(100*number,z6.),B8601TM6.);