Number of employees function

[brianwakin]

With data in the format below, how can I get Excel to tell me how many
employees are on the schedule at 7AM, 8AM, 9AM, 10AM, 11AM, 12PM...8PM?

Admin Assistant IN OUT
Matt 7:00 AM 5:00 PM
Nelly 8:00 AM 7:00 PM
Natalie 9:00 AM 1:00 PM
Merium 2:00 PM 6:00 PM
Martha 3:00 PM 8:00 PM

Any help would be appreciated.

 

[Jim Thomlinson]

The easiest way is to create a pivot table off of the data. Select Data ->
Pivot Table
Follow the wizard. Place the Start times in the left hand column and the
names in the center.

 

[sebastienm]

Hi,
Assuming Names are in A2:A10, IN in B2:B10, and OUT in C2:C10.
Say your constraints are in E1 and F1. In G1, enter the formula:
=SUMPRODUCT(($B$2:$B$10>=$E$1)*($C$2:$C$10<=$F$1)*1)