You need to FORMAT/CELLS/CUSTOM to look like this [h]:mm
Matt
doyouknow2005 Wrote:
I am trying to add many hours and minutes in a "work hours" type of
format that add up to more than 24 hours ie: 2:03+4:52+6:35+6:10+8.52
= 28:32etc. I want it to end up with a total in hours and minutes but
not time of day. Looking through the help feature did not help.
--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile:
http://www.excelforum.com/member.php...o&userid=15310
View this thread:
http://www.excelforum.com/showthread...hreadid=385985