Converting hundredths
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?
|