calculating number of hours

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

Guest

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!
 
Hi Ken,

Assuming:

A1=13:36
B1=01:45

try,

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

Hope this helps!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate After hours 3
work hours with different hour prices 12
Calculating time for 3rd shift 4
Time Calculation 9
elapsed time displayed as a decimal 1
I need calculated time in a "real number" format 2
How do I limit formula results to positive only? 4
Daily Time Sheets with Rounding 1

Back
Top