Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating hours
I am trying to register my working hours, but when I try to add up a column
of hours it only adds up correctly if the total is less than 24 hours. How do I correct this? -- Thomas Jørgensen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating hours
Are you really adding times...
Maybe it's adding correctly, but not displaying what you want. Try changing the number format for that cell to: [hh]:mm:ss Thomas wrote: I am trying to register my working hours, but when I try to add up a column of hours it only adds up correctly if the total is less than 24 hours. How do I correct this? -- Thomas Jørgensen -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Hours | Excel Worksheet Functions | |||
Calculating hours between 35 and 40 | Excel Worksheet Functions | |||
Calculating Hours | Excel Worksheet Functions | |||
Calculating hours | Excel Worksheet Functions | |||
Calculating Hours | New Users to Excel |