Calculating time, hours and minutes

A

arrowpilot

I am trying to total time in hours and minutes. Example, 1 week I earn 2
hours 12 minutes comp time, next week 1 hour 13 minutes. How can I get the
total to equal 3 hours 25 minutes?
 
P

Pete_UK

If the cells are formatted as Excel times, then you can just add them
up, eg =A1 + A2 + A3 etc. You might like to apply a custom format of
[h]:mm to avoid rounding into days above 24 hours.

Hope this helps.

Pete
 
Top