Time in hours.hundredths

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a worksheet to calculate my hours at work. However, in this new job the time clock punches in military time
hours:hundredths of an hour, i.e. 1:35 pm is 13:75 on the time card. I cannot find a format for hours:hundredths. Is there some way that I can make that format or calculate using hundredths of an hour?
 
Hi

13.75 maybe is the number you have there. When yes. then you can convert it
into time with formula
=13.75/24
and format the result as "hh:mm" or "[h]:mm"


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


Ed said:
I am making a worksheet to calculate my hours at work. However, in this
Click to expand...
new job the time clock punches in military time,
hours:hundredths of an hour, i.e. 1:35 pm is 13:75 on the time card. I
Click to expand...
cannot find a format for hours:hundredths. Is there some way that I can
make that format or calculate using hundredths of an hour?
 
Back
Top