May 16 2019 12:13 PM
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.
May 16 2019 01:34 PM
@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.
May 16 2019 02:37 PM
May 16 2019 02:40 PM - edited May 16 2019 02:42 PM
@Detlef LewinIt is attached.
May 16 2019 03:04 PM
@griam01 , check your source data formatting