Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables (% to total within groups) | Excel Discussion (Misc queries) | |||
Pivot tables and total count | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions | |||
how do I get more than one sub-total in pivot tables? | Charts and Charting in Excel | |||
Total two pivot tables into one | Excel Worksheet Functions |