Grouping Date/Time Data in a Pivot Table not working

Copper Contributor

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.

 

Capture.PNG

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.

@griam01 

Could you provide the file?

 

@Detlef LewinIt is attached.

@griam01 , check your source data formatting

image.png