View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 99
Default 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