| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time over 24 hours
I'm creating a custom timecard to compute time spent by a given employee on
various projects. When I try to add daily totals together to get weekly totals and that total exceeds 23:59, I can't find a format that will display it as such -- it always reduces it to a time under 23:59. (Example: 14:30 + 12:18 = 26:48, but it displays as 2:48) How can I fix this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time and Business Hours | Excel Worksheet Functions | |||
| time | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
