Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time greater than 9999:56
cells are formatted to [h]:mm and will not use a number higher than 9999:56
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time greater than 9999:56
Hi!
You can manually enter time values up to 9999:59, above that they are automatically evaluated as GENERAL TEXT values. You can calculate time values well in excess of 9999:59 A1 = 9999:59 A2 = 9999:59 =SUM(A1:A2) Returns 19999:58 Biff "PapaT" wrote in message ... cells are formatted to [h]:mm and will not use a number higher than 9999:56 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time greater than 9999:56
Use this technique, assume you have 35523 hours and you want to add 11450
hours to that, use =(35523/24)+(11450/24) or if you have the times in cells A2:A3 =SUM(A2:A3)/24 returns 46973:00:00 formatted as [hh]:mm:ss -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "PapaT" wrote in message ... cells are formatted to [h]:mm and will not use a number higher than 9999:56 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Worksheet Functions | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
count TIME that is GREATER than 24 hours | Excel Worksheet Functions |