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?
@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.
1) For the daily time, use the following formula in H4:
2) For the weekly total, use the following formula in H9:
and apply the custom number format [hh]:mm to H9.