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?
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.