Forum Discussion
Pivot Table Avg Times
Good morning, I am attempting to create an excel pivot table that takes avg times per day so that I can plot in a bar chart. I would like to group each time by hour and calculate how many instance...
Hi elisprague
#1 How do you calculate the expected average? i.e.:
#2 What version of Excel do you run + on which Operating System (Windows, Mac...)?
As you can see, this is how these averages are calculated manually, I want to find a way for pivot table to automatically calculate these averages from the entire data source.