I have a column of dates and a column of names, where I’m trying to evaluate the data to see quantities per hour by person.
If I use the Recommended PivotTable wizard in Excel for one month’s worth of data, it breaks it down by day then hours, and if I remove the day Rows in the PivotTable sidebar, under each person I then get it grouped and counted by the hours (9am, 2pm, etc.). If I try to do this for more than a month’s worth of data though, I only get Months in the Rows area of the sidebar. How can I get it to do it by Hours there too when it isn't the same month's worth of data?
Sample of data from first column below
6/6/2022 9:16
7/8/2022 14:19
7/8/2022 12:41
If I use the Recommended PivotTable wizard in Excel for one month’s worth of data, it breaks it down by day then hours, and if I remove the day Rows in the PivotTable sidebar, under each person I then get it grouped and counted by the hours (9am, 2pm, etc.). If I try to do this for more than a month’s worth of data though, I only get Months in the Rows area of the sidebar. How can I get it to do it by Hours there too when it isn't the same month's worth of data?
Sample of data from first column below
6/6/2022 9:16
7/8/2022 14:19
7/8/2022 12:41