PivotTable only breaks down by month, not hours

[vhqyqqdw]

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

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: PivotTable only breaks down by month, not hours
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Alex Blakenburg]

Have you right clicked in the Pivot Table field selected Group and selected Month and Hours ?

 

[vhqyqqdw]

Have you right clicked in the Pivot Table field selected Group and selected Month and Hours ?

View attachment 69376

That did it, if I just change it to hours, all the items under each person change to the hour headings like 7 AM, 2 PM, etc. I knew I was missing something easy, thank you!!

 

[vhqyqqdw]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: PivotTable only breaks down by month, not hours
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thanks, didn't realize there was an affiliation between different websites like that, so thought posting on more was better as I usually don't have good luck with forums.

 

[Fluff]

We are not affiliated, but all Forums have much the same rule about cross-posting.

 

[Alex Blakenburg]

That did it, if I just change it to hours, all the items under each person change to the hour headings like 7 AM, 2 PM, etc. I knew I was missing something easy, thank you!!

Thanks for letting us know. Glad we could help.