Forum Discussion
Grouping Date/Time Data in a Pivot Table not working
I am trying to follow the instructions as outlined here to group by hours:
https://www.extendoffice.com/documents/excel/4822-excel-pivot-table-group-by-hour.html
The issue is that when I right click and choose group, I don't see the date/time format although it shows in my Pivot table.
How can I convert the data properly? Thanks in advance for the assistance.
5 Replies
Detlef_Lewin I had previously checked this link and the solutions and none of them worked for me. I tried reformatting the data in the original raw data and now I have where it says it cannot group that selection. I confirmed the Date column on the original raw data is formatted as mm/dd/yy hh:mm.
