G
Guest
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?
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?