Jan 13 2021 02:38 PM
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?
Jan 13 2021 02:51 PM
@StephBarr Here's an article that further explains the issue. 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.
Jan 13 2021 02:58 PM
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.