Count of different shifts done by each employee
I have my team members doing 3 different shifts and is rotated as and when required.
At the end of each month, I would like a count of each of the 3 shifts done by each employee.
Eg. Employee A did 5 days of 8 AM to 6 PM, 10 days of 7 AM to 5 PM and 7 days of 10 AM to 8 PM shifts.