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

[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.

 

[Bob Phillips]

=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