Pivot Tables : Total Time incorrectly computed
 

Hello,
I have a pivot table with time (number of hours worked during the week.
However if a time is that 24:00 it's start again at 00:00. This is really
annoying as the total is used to compute other stuffs.
Any workaround will be appreciated.

Many thanks

Pivot Tables : Total Time incorrectly computed
 

Hi

Really it doesn't start at 00:00, but continues from 1 00:00 , i.e. you got
a full day, which lasted 24 hours, meanwhile. To display result as hours,
format the range with hours worked in your pivot result table as custom
"[h]:mm".


Arvi Laanemets


"François" wrote in message
...
Hello,
I have a pivot table with time (number of hours worked during the week.
However if a time is that 24:00 it's start again at 00:00. This is
really
annoying as the total is used to compute other stuffs.
Any workaround will be appreciated.

Many thanks