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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating hours with custom [t]:mm:ss
"Hans" wrote in message
... 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. Any date and/or time value is stored such that one day is 1. So an hour is 1/24 (approx. 0.0416667). Therefore, when you do calculations on dates/times, you have to multiply by 24 to get the result into hours. Formatting does not change the value - it merely changes how it is displayed. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating hours with custom [t]:mm:ss
Thanks for info. Didn't know that.
"Stephen" wrote: "Hans" wrote in message ... 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. Any date and/or time value is stored such that one day is 1. So an hour is 1/24 (approx. 0.0416667). Therefore, when you do calculations on dates/times, you have to multiply by 24 to get the result into hours. Formatting does not change the value - it merely changes how it is displayed. |
Reply |
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 |