Hi, I am trying to find out the best way to setup an excel spreedsheet to help calculate the number of employees I have scheduled to work per hour. I have a bunch of shifts, and several teams.
I have several teams, example team 1, team 2, team 3, etc.
Each team has 9 to 15 employees on them. I need to somehow figure out how much employees working at any given hour for a 24hr period. Not sure I have explained it correctly, but hope someone can give me a head start.