count scheduled staff between hours

J

jat

i am using the weekly schedule from the microsoft templates at
http://office.microsoft.com/en-us/templates/TC300023281033.aspx?pid=CT101172751033&WT.mc_id=42

i was wondering if it is possible to count the number of staff that are
scheduled for each hour.

ex. fill in the schedule for Sunday (assormtment of shifts); 10:00-16:00;
10:00-17:00; 13:00-17:00;

How many staff are scehduled between 10:00 - 11:00 on Sunday?
formula would return 2
How many staff are scheudled between 11:00 - 12:00 on Sunday?
formula would return 2
How many staff are scheduled between 12:00 - 13:00 on Sunday?
formulat would return 2
etc....

need to know if it can be done? i would be doing this for each day of the
week, for each hour between 7AM and 9PM. one value in each each.

any help to get me going would be appreciated.

thank you,

jat
 

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

count how many staff are scheduled between... 3
Countifs with different restrictions 1
Peak call times/hours 2
Count time formatted data within range 1
still having trouble with this.... 4
Modifying a complex date formual to count months 4
Resourcing and counting staff 1
Add Hours by Looping through Data Q 27

Top