Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating hours with custom [t]:mm:ss
I am trying to do simple calculations like division, multplication etc. The
hours are in format [t]:mm:ss in a pivot table. The results of the calculations do not make any sense. I would like to calculate the number of workdays from the amount of hours i.e. divide hours with eight. I am using excel 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating hours | Excel Discussion (Misc queries) | |||
Calculating hours | Excel Worksheet Functions | |||
calculating hours in one cell | Excel Worksheet Functions | |||
Calculating working hours | Excel Discussion (Misc queries) | |||
calculating hours | Excel Worksheet Functions |