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...)?
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.
Have taken a sligthly different route as it seems MROUND does not always put the [Arrival Time] in the appropriate Time Slot:
In attached file the Avg measure is SergeiBaklan's one
