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.
Lorenzo I use Microsoft excel.
Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit
- Hi Sergei, thank you for responding. I am interested in the occurrences and not the avg times. Our goal is to find out the average number of appointments at specific times a day so that we can plan staff scheduling accordingly.
