Thread
:
add times
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Bob Phillips[_3_]
external usenet poster
Posts: 2,420
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.
Reply With Quote
Bob Phillips[_3_]
View Public Profile
Find all posts by Bob Phillips[_3_]