Check if time range is within another time range

Try the following**:

Formula:

=SUM(IFERROR((ISNUMBER(SEARCH("*Test*",$A$2:$A$10)))*(VALUE(LEFT(C$2:C$10,5))<=VALUE(LEFT($B13,5)))*(VALUE(RIGHT(C$2:C$10,5))+(VALUE(RIGHT(C$2:C$10,5))< VALUE(LEFT(C$2:C$10,5)))>=VALUE(RIGHT($B13,5)))*(VALUE(LEFT(C$2:C$10,5))<=VALUE(LEFT($B13,5)))*(VALUE(RIGHT(C$2:C$10,5))+"24:00:00">=VALUE(RIGHT($B13,5))),0))

**Array entered formula (see post #20)
Let us know if you have any questions.