I have written a shift planner and want to count how many staff are in work in the morning and the afternoon. They can start at anytime from 6am and for the purpose of afternoons I have set that to start at 12pm.
I write each shift as 7am - 3pm, 8am - 4pm etc.
I can count the number of instances:
But wanted to count all instances that start from 6am to 12pm for the morning. Then all that include 12pm onwards. Is this possible or can you guide me on an alternative. I don't mind changing the format.