Timecard - Adding Hours for total

Occasional Visitor


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

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