## Time Conversion

Solved
Occasional Contributor
Posts: 12

# Time Conversion

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.

Accepted Solutions
Solution
‎07-26-2016 01:48 AM
Super User
Posts: 6,849

## Re: Time Conversion

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.);``

All Replies
Super Contributor
Posts: 260

## Re: Time Conversion

do you want to see your data as mentioned below

02:50

01:03

03:56

Solution
‎07-26-2016 01:48 AM
Super User
Posts: 6,849

## Re: Time Conversion

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.);``
☑ This topic is solved.