| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show negative time (e.g. -10 hours) | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
| time format multiplied by hours worked ? | Excel Worksheet Functions | |||
| Count items between specific hours on a matching date | Excel Worksheet Functions | |||
Hybrid Mode
