Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My data has a col called Dur which is a calculation subtracting one time from
another time. Depending on my filtering in the pivot table depends on how many cells contain ###. I have the data formatted as General and Dur in the PT is formatted as custom [h]:mm:ss Any assistance with getting my data to show up as hh:mm:ss to replace the ### would be appreciated. -- Thanks, Judy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Showing all rows in a pivot table | Excel Discussion (Misc queries) | |||
Value not showing in pivot table | Excel Discussion (Misc queries) | |||
Pivot table NOT showing zero value calculations | Excel Worksheet Functions | |||
pivot table showing row field with no value | Excel Discussion (Misc queries) | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) |