Count if between range of times

[javoseabaugh]

I have a spreadsheet with two sets of data. One has Overtime with start and end time and on the other tab I have a table to 30 minute intervals and I am trying for excel to tell me how many people I have working OT during that 30 minute interval. I can't figure it out. Please help

[#2]

There is no set of people in your OP.  Impossible to answer.  Probable answer:  Loop thru people with BYROW, FILTERing the other tables to figure out what OT they are doing.

[#3]

@javoseabaugh 

Perhaps

=SUMPRODUCT(
    ($N$3:$N$18 >=$P3) *
    ($N$3:$N$18 >=$Q3) *
    ($L$3:$L$18 <= $P3) *
    ($H$3:$H$18="Overtime")
)

 for