Hello. I am having a hard time figuring out how to use functions to count the number of staff I have working during each hour of the day. I am a beginner, but I enlisted the help of someone who has more experience and they aren’t able to figure it out either.

I have 45 employees in a 24/7 department, so there are night shift staff that start on 1 day and finish on the next – that is throwing a huge wrench into things. 

The schedule also has 30 minute lunches built into their day, so there is a 30 minute overlap that I don’t want to include those people into.

I do my schedule in excel per pay period as shown below. I am willing to adapt the way I currently do the schedule if needed, I just need to save myself time and prevent miscounting errors. 

Any help would be appreciated.

​Hello. I am having a hard time figuring out how to use functions to count the number of staff I have working during each hour of the day. I am a beginner, but I enlisted the help of someone who has more experience and they aren’t able to figure it out either. I have 45 employees in a 24/7 department, so there are night shift staff that start on 1 day and finish on the next – that is throwing a huge wrench into things. The schedule also has 30 minute lunches built into their day, so there is a 30 minute overlap that I don’t want to include those people into. I do my schedule in excel per pay period as shown below. I am willing to adapt the way I currently do the schedule if needed, I just need to save myself time and prevent miscounting errors.  Any help would be appreciated.  Read More

​