format the total cell as [h]:mm and you will get more than 24 hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tcs" <tsmith@eastpointcityNoSpamorg wrote in message
...
I have multiple rows with start & stop times (morning & afternoon). I
total
them in the 5th column. I then want to total the 5th column. (1 week
groups, 7
rows).

1-Nov-04 8:00 12:00 13:00 17:00 8:00
2-Nov-04 8:00 12:00 13:00 17:00 8:00
3-Nov-04 8:00 12:00 13:00 17:00 8:00
4-Nov-04 8:00 12:00 13:00 17:00 8:00
5-Nov-04 8:00 12:00 13:00 17:00 8:00
weekly total 16:00

The first part isn't a problem. I get the correct value in the 5th
column.

The SECOND part is another story. When I add the 5 rows of the 5th column
(5
days * 8/hrs/day) SHOULD equal 40 hours. Instead, Excel tells me it's
only
16:00 hours. What am I doing wrong? I've checked the formatting, and
BELIEVE
it to be corect.

Thanks in advance,

Tom