Formula for calculating time

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

Guest

I am establishing a Timesheet for our business in Excel. I have cells for
"In" , "Lunch Out", "Lunch In" and "Out" that employees will enter their
times (in military time). Need the formula that will calculate the total
hours for the day, subtracting out for the lunch break.

Thanks!
 
Hi!

B2 = time in
C2 = lunch out
D2 = lunch in
E2 = time out

Total =IF(C2="","",(E2-D2+(D2>E2)+C2-B2+(B2>C2)))

Returns in the format of h:mm - 8:45

For a return in decimal format - 8.75

=IF(C2="","",(E2-D2+(D2>E2)+C2-B2+(B2>C2))*24)

Biff
 
Back
Top