calculating number of hours

[Ken Johnson]

I am looking for help calculating number of hours worked. Example: on at 1336 off at 0145 for a result of twelve hours and nine minutes, then converting that to tenths of hours. 12.15 hours Thanks!

 

[Domenic]

Hi Ken,

Assuming:

A1=13:36
B1=01:45

try,

=(B1-A1+(B1<A1))*24

Hope this helps!

 

[Frank Kabel]

Hi Ken
enter your time values as real times. e.g.
a1: 13:36
B1: 01:45

And now the formulas:
C1: =B1-A1+(B1<A1)
and format this as time

D1: =C1*24
and format this as number