count TIME that is GREATER than 24 hours

J

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?
 
N

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
[email protected]
 
Top