Add your times normally, and format the result cell with a custom
number format of [hh]:mm or [hh]:mm:ss. The square brackets
prevent Excel from rolling over at 24 hours.


"doyouknow2005"

wrote in message
news:doyouknow2005.1rz2aa_1121029501.2838@excelfor um-nospam.com...

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.


--
doyouknow2005
------------------------------------------------------------------------
doyouknow2005's Profile:
http://www.excelforum.com/member.php...o&userid=25085
View this thread:
http://www.excelforum.com/showthread...hreadid=385985