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.

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.

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.