count TIME that is GREATER than 24 hours

G

Guest

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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif with two criteria 2
Subtracting time...again 2
Calculate elapsed time excluding specific timeframe 10
Formula help 0
how do I calculate a week days hours with the 24hour clock 5
TIME CALCULATION 5
Adding Times 7
Wrong count of time 7

Top