Adding hours and minutes

[doyouknow2005]

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]

You need to FORMAT/CELLS/CUSTOM to look like this [h]:mm

Matt

 

[Chip Pearson]

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"
<[email protected]>
wrote in message
news:[email protected]...