Timecard - Adding Hours for total

Occasional Visitor

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

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

@StephBarr 

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.