Calculate total in range that are before specific time:

[BastImret]

I hope I can explain this clearly.
I have a range of A11:A18 that contain times (1700, 1800, 1900, 2000 through 2400 currently.)
B11:B18 is where the number of slots open that I'm tracking are recorded.
Range I3:K8 contain:
I= Slot labels
J= Slot open times
K= Slot close times

With B11 is where how many slots remain open at 1700 is input, I'd like a formula to auto fill that number based on the times in the range I3:K8.

Attached is a sample which I hope better explains what I'm trying to accomplish. I'm not certain the best approach for this other than no VBA.

[BastImret]

I'm thinking a formula that counts how many K3:K8 have times that are below 2400, how many below 2300, below 2200, and so on?

[BastImret]

I'm not sure how to even tell excel that 0100 is after 2400...

[bebo021999]

Because your number-store-as text, try to convert them to real number, by this:
Copy any blank cell
Highlight the range A11:A18
Paste special/value and Operation: Add
Format to be general
Similar to J and K
Then in B11:

=COUNTIFS($J$3:$J$8,"<="&A11,$K$3:$K$8,">="&A11)

OR, if dont change format, in B11:

=SUMPRODUCT(($J$3:$J$8+0<=A11+0)*($K$3:$K$8+0>=A11+0))

[BastImret]

bebo021999, the times in A11 through, can run from 1700 to 0200. I'd need a way (maybe a helper column) that determines 0100 later than 2400 for example.
1700
1800
1900
2000
2100
2200
2300
2400
0100
0200

[bebo021999]

I can see the data validation source in R:S display 17:00-24:00?
Can you type the real time range and some of cases those representative 0100 or 0200 and mock up results?

[BastImret]

Attached is report from yesterday. Stripped of sensitive data and whatnot.
I left the areas that I'm working on as is for a real world example...
The actual times that are tracked hourly are from 1700 through 0200 for our business day. The 24hour time format and general layout are decided by the powers that be, above my pay grade.

[bebo021999]

Inteprete time that less than 0200 to plus 1 day = 2400

Try:

=SUMPRODUCT(($J$11:$J$16 <=(A29+(A29+0 <=200)*2400))*
(($K$11:$K$16+($K$11:$K$16+0 <=200)*2400) >=(A29+(A29+0 <=200)*2400)))

[BastImret]

bebo, thank you for the help. Your solution worked perfect