# Thread: Problem: Decimal time to Standard Time

1. ## Problem: Decimal time to Standard Time

I have been writing a gateway for a payroll program, and the data is exported from the timeclock in decimal (9.50 rather than 9:30)

Is there any way to convert these times with a calculated field?

I broke out the decimal portion with the INT() command, but then when I total all the individual lines for an employee it doesn't recognize that the integer portion should increase after 59 minutes, so I end up with something like this: 77:70.

2. ## RE: Problem: Decimal time to Standard Time

From my interactive editor
Decimal_time = 9.50
Time = alltrim(str(int(Decimal_time)))+":"+alltrim(str(mod(Decimal_time,1)*60))
?time
= "9:30"

3. ## RE: Problem: Decimal time to Standard Time

Thank you very much!

4. ## RE: Problem: Decimal time to Standard Time

BEAUTIFUL STEPHO

Kenno

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•