add times

  • Thread starter Thread starter add times
  • Start date Start date
A

add times

I am trying to add this times in my time sheet but I don't know what I'm
doing wrong
8:00 =TEXT(E7+H7,"h:mm) This is the formula I used to get the total for the
day and is ok but know I can't get the total for the week


I used this =SUM(I7:I10) but it won't work.
 
Hi,

If the cell I7 is working then I suppose you have time entered as times in
E7 and H7?
If that is the case why both with the TEXT function, instead use =E7+H7 and
format the cell to [h]:mm.

Then you can get the weekly total with =SUM(I7:I11) - this cell needs to be
formatted as above [h]:mm:ss or [h]:mm

If you really want the text times than you can use either one of these

=SUMPRODUCT(VALUE(I1:I5))
=SUMPRODUCT(--I1:I5)
 
Back
Top