ADDING TIMES
You use the wrong format, use [h]:mm
--
Regards,
Peo Sjoblom
"William" wrote in message
...
I would like to add hours in a worksheet to come up with a total number of
hours. However, when I add something like this:
5:00
5:00
5:00
5:00
5:30
. . . the answer is 1:30. So excel is taking 25 hours and 30 minutes and
representing as 1:30.
How can I get excel to return the total hours total as hours (25:30)?
Thanks
--
William
|