how do I set count the number of staff in a rota working per hour

  • Thread starter Thread starter Scott Cheesman
  • Start date Start date
S

Scott Cheesman

Hope someone can help.

I've got a rota for waiting staff, and I need to make a table of how many
waiters are working per hour.

The table goes from 9am until 11pm.

Waiting staff hours change, and can be from 10am to 3pm or 12pm until 9pm etc

Any help, would be greatly appreciated.

Thanks

Scott.
 
=SUMPRODUCT(--($C$2:$C$20>=D$1+"1:00"),--($B$2:$B$20<=D$1))

where the times are in D1, E1, ..., the employee start times in B, end times
in C
 
Back
Top