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