Pivot Tables : Total Time incorrectly computed

[François]

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

[Arvi Laanemets]

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" <Franois@discussions.microsoft.com> wrote in message
news:C2C33404-1EF1-4068-A5F6-34989EEA357B@microsoft.com...
> 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

[Daniel Black]

Help Im trying to calculate the number of hours worked on different projects but im having real trouble,
I have calculated manually that a caseworker has completed one piece of work for 95 minutes and should appear as 1.35 but currently appears as 192.00 even with the cell formatted with [H]:mm

can someone please help me??????????

[DonkeyOte]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.