COUNTIF for DOW Staff by Interval

Hi Guys!

I currently have a file that calculates the # of staff by interval for each day of the week based on their shift/schedules. I'm running into a problem with overnight schedules. See the file sample, A:B show shift start/stop and C:I each day of the week with the following formula being used on M:S =COUNTIFS(C:C,M$2,$A:$A,"<="&$K18,$B:$B,">="&$L18)

As you can see, those shifts in row 10 through 13 are not being accounted for. I have searched for weeks and have yet to find a formula that helps with the overnight headcount and have been manually adding/removing those shifts.

Thank you all for any input/help on this one.

Let's see if it works fine in your mind, I just played with time, no formula. I added 1 to the decimal time in column A&B and pushed start time scale for 8:30.

Thank you so much! I see the new format does count the headcount as needed. Much appreciated!!!!

Thank you so much! this solved my problem!

Great, tks for the feedback.