how many people are scheduled between...
 

i am using a schedule template from excel templates.
Column A: Name
Column B: Start Time (Sunday)
Column C: End Time (Sunday)
Column D: Start Time (Monday)....
Row 3: Emp 1
Row 4: Emp 2
Row 5: Emp 3...

i enter staff hours for Sunday:
Emp 1 - Start 10:00, End 17:00
Emp 2 - Start 10:00, End 12:00
Emp 3 - Start 11:00, End 14:00

in Cell A1, i want to know how many people are scheduled between 10 and 11
AM. 2 is the answer, but is there are way to create a formula for this. i
would need to do this for the entire weekly schedule (7 days, time frame of
7am to 9pm - hourly).

thank you,

jat