count TIME that is GREATER than 24 hours
 

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?

Jon

Simply add them but the key is the formatting. (FormatCellsCustom)

[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
HIS

"JonPilot" wrote in message
...
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?