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

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.

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

=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

--
__________________________________
HTH

Bob

"Scott Cheesman" <Scott wrote in message
...
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.