Forum Discussion

elisprague's avatar
elisprague
Copper Contributor
Dec 18, 2023

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 instances where those times appear (per hour). The column/variable of interest is "Arrival Time." I have put the times in the rows (In pivot) but when I attempt to put the times in the values and average them, excel won't calculate the average instances of those times.https://mothership2022-my.sharepoint.com/:x:/g/personal/elsprague_thecounselingcenter_org/EfGNasL9rxdJivBrkAftlIABIUAvBCYMbUdqvRfrFGODnA?e=Ykl3Oc 

 

Resources