I am trying to group the columns in the attached PivotTable to:
- 0.7.5: Morning Shift
- 8-17.5: Day Shift
- 18-24: Night Shift
Also, I am trying to turn column C into a Date field (which is what it is) so I can group that column into weeks. I have tried changing the formatting but the pivot table is just not recognising it as a date.
Can someone please edit the attached PivotTable to make these 2 things happen.