Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate the sum of hours exceeding 23:56
tell me how to add the sum of hours together which exceed 23:59
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate the sum of hours exceeding 23:56
Just add as usual, use a custom format of [hh]:mm otherwise it won't display
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "charllie" wrote in message ... tell me how to add the sum of hours together which exceed 23:59 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate hours in Excel | New Users to Excel | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
calculate hours on work sheet | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions |