| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hour Totals
When I reach a total hours over 9999:00:00 the sum will not add up. How can
this be fixed. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hour Totals
When I add 9000:00:0 to 7000:00:00, I get 16000:00:00
What is your difficulty? -- David Biddulph "runner" wrote in message ... When I reach a total hours over 9999:00:00 the sum will not add up. How can this be fixed. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hour Totals
They add up for me. I can display a sum of 10000:00:00. Give us more
information on what you are doing. Another option may be to eschew times, and just enter your hours as numbers with whatever precision you want (ie, 1 or more decimal places). You'll have more control over the formatting then. Regards, Fred. "runner" wrote in message ... When I reach a total hours over 9999:00:00 the sum will not add up. How can this be fixed. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hour Totals
=24*INT(SUM(A20+A21))+HOUR(SUM(A20+A21))&":"&TEXT( MINUTE(SUM(A20+A21)),"#00") "runner" wrote: When I reach a total hours over 9999:00:00 the sum will not add up. How can this be fixed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help adding up hour totals on a logbook | Excel Discussion (Misc queries) | |||
| Converting from 12-hour to 24-hour format | Excel Worksheet Functions | |||
| Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Linear Mode
