Forum Discussion
Timecard - Adding Hours for total
Hello-
I am trying to sum up the total hours for a week from the daily - and a basic sum function doesn't work. I have attached the file. Can anyone help?
2 Replies
1) For the daily time, use the following formula in H4:
=MAX(D4+G4-$I$2,0)
2) For the weekly total, use the following formula in H9:
=SUM(H4:H8)
and apply the custom number format [hh]:mm to H9.
StephBarr Here's an article that further https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-times-e1c78778-749b-49a3-b13e-737715505ff6. What I applied to the yellow range is multiplying the result by 24 and converting it to a Number.
In regard to solving column H, the error is the subtracting of a number with a timeslot. If you populate columns E:G, a simple subtraction between D and G should work.
