Converting hundredths

[Kim DuBray]

I have a timesheet that calculates hours worked. I'd like to enable the data
entry person to enter the military time in hundredths. My current formula for
calculating the hours is:
((F6 (time out)-C6(time in)+(f6<c6))*24. However, our timeclock generates
military time in hundreds, i.e... 14:99-21:96. Is there a way to make the
timesheet allow the entry of time in hundredths and then calculate the hours?

 

[Gary''s Student]

Actually your application is easier than hours:minutes. Just enter the
values as:

14.99 rather than 14:99 and do not format as time. Format as general.

Then 21.96 - 14.99 = 6.97 hours


If you need to convert back to hours:minutes, just multiply the fraction by
60. So 6.97 hours will become 6 hours 57.6 minutes.