calculating hours with custom [t]:mm:ss

[Guest]

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.

 

[Stephen]

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.

 

[Guest]

Thanks for info. Didn't know that.

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.