i am using a template from office.excel for a schedule.

i want to know if it is possible to do the following:

Column A: Employee Name
Column B: Sunday Start Time
Column C: Sunday End Time
Column D: Monday Start Time....

Row 5: Emp 1
Row 6: Emp 2
Row 7: Emp 3...

Emp 1, Sunday schduled 10:00 to 17:00
Emp 2, Sunday schduled 10:00 to 12:00
Emp 3, Sunday schduled 11:00 to 16:00...

in cell A15, i want to know how many people are schduled on Sunday between
10:00 and 11:00 (formula would return 2 - because two people are schduled to
be there between 10 and 11 AM); in A16, time frame would be 11AM to 12 PM
and the value returned would be 2;

can this be done in excel?