Greetings,

I have a list of events along with the times they occurred. I want to group the times into shifts with the display being 1 for the first shift (midnight to 7AM), 2 for the second shift (7AM to 3PM), and 3 for the third shift (3PM to midnight). I then plan on putting my data into a pivot table so that I can easily count the events with the rows displaying as a 1,2,3 for each shift.

Any help would be much appreciated.