| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated field in Pivot Table
I am having problems with a calculated field in my pivot table. I have each
persons daily time available in a column, the table averages that data for each person, the only problem is the time is in seconds and I want to convert it to hours. It is too cumbersome to manually change the source data everytime I add records. My calculated field divides "available time" by 3600. Unfortunately the pivot table sums the results. I just want the calculation. I cannot change the sum function in the table wizard. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| calculated field - Pivot Table | Excel Worksheet Functions | |||
| calculated field in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Field- Help | Excel Discussion (Misc queries) | |||
Threaded Mode
