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.

add times
 

=SUMPRODUCT(--(I7:I10))

--
__________________________________
HTH

Bob

"add times" <add wrote in message
...
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.

add times
 

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)
--
Thanks,
Shane Devenshire


"add times" wrote:

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.