Time in hours.hundredths

[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?

 

[Arvi Laanemets]

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)

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?

 

[Guest]

Thanks Arvi, works like a charm.