Forum Discussion

griam01's avatar
griam01
Copper Contributor
May 16, 2019

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 c...
grouping
pivot table
  • griam01's avatar
    griam01
    Copper Contributor
    May 16, 2019

    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.

Resources