converting hours to decimals

  • Thread starter Thread starter bootscootingab
  • Start date Start date
B

bootscootingab

i need a formula to calculate the following:

employee #1 stated work at 805am
went to lunch at 1107am
returned at 1221am
ended work at 546am

i need the total time worked for this day to be calculated into
decimal figure.

hel
 
Use real time entries like 08:05 AM, the you can use this formula

=(D1-A1-(C1-B1))*24

where D1 holds 05:46 PM (I am assuming you had a typo)
A1 holds 08:05 AM
C1 holds 12:21 PM (again assuming a typo or else you don't know time)
B1 holds 11:07 AM

better way (IMHO) is to use 08:05, 11:27, 12:21 and 17:46

no AM/PM involved
 
Assume Start time is in A2, Lunch Start in B2, Lunch End in C2, Day en
in D2

copy this formula in E2

=((B2-A2)+(D2-C2)-(C2-B2))*24

Format E2 to numbe
 
Back
Top