Headcount based on scheduled hours vs individual hours

[klturi421]

I have a document with hundreds of start and stop times for employees. I am attempting to determine headcount for specific hours.

Example:
Employee 1 works from 1:00 PM to 7:00 PM. I have the time listed out 1:00 PM through 7:00 PM and each time the person is scheduled to work it counts 1. Furthermore, if I have 10 people working at 1, then 10 should appear, if 20 people are working at 2:00 PM then 20 should appear, etc.


I'm imagining some sort of COUNTIFS formula but I can't quite figure out the correct sequence.

I have included a sample doc to better illustrate what I am looking for.

[CAntosh]

If I'm understanding your sheet correctly, then you're on the right track with COUNTIFS. Try the following in F3:

=COUNTIFS($A$2:$A$10,"<="&F2,$B$2:$B$10,">"&F2)

...and fill right. Adjust for Wed. in F8:

=COUNTIFS($C$2:$C$10,"<="&F7,$D$2:$D$10,">"&F7)