count TIME that is GREATER than 24 hours

[JonPilot]

in Excel, I want to add TIME cells greater than 24 hours, e g 22:00 + 20:00 I
want the spreadsheet to return an answer of 42:00

Is this posible?

 

[Nick Hodge]

Jon

Simply add them but the key is the formatting. (Format>Cells>Custom)

[hh]:mm

the [ ] will stop it incrementing to days. you can also use [mm]:ss for
minutes over 60

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)