| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum hours
How do I sum or total up hours when the total goes over 23:99? Excel tend to
revert back to 0:00 once it reach 24:00. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum hours
Format the cell as [h]:mm
The brackets keep the hours from rolling over. Biff "JJ Goh" <JJ wrote in message ... How do I sum or total up hours when the total goes over 23:99? Excel tend to revert back to 0:00 once it reach 24:00. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Linear Mode
