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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I count a rota with no dates and using 24 hours clock 2
How to project the due date according to a number of working hours 6
patients per hour 9
How do I add up the last 12 cells (containing values) in a column. 4
How do I set up a formula for parts (or units) per hour? 10
Counting cells 2
How do I count the number of each number in a column? 5
How do I run a query depending on the result of a count query? 3

Top