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.
