Adding hours and minutes
 

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

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

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