G Guest May 28, 2004 #1 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!
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!
D Domenic May 28, 2004 #2 Hi Ken, Assuming: A1=13:36 B1=01:45 try, =(B1-A1+(B1<A1))*24 Hope this helps!
F Frank Kabel May 28, 2004 #3 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
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
