I've used the formula =COUNTIFS(Schedule!$AC$6:$AC$96,"<"&AE$34,Schedule!$AD$6:$AD$96,">"&AD$34) for all other hours, but for a shift that spans across midnight (i.e. 11:00PM-12:00AM, 12:00AM-1:00AM, 1:00AM-2:00AM, etc.), my formula doesn't work! My AC6:AC96 are shift start times, AD6:AD96 are shift end times, AD34 and AE34 are my paramaters (11:00 PM and 12:00 AM, respectively). I am using the custom format h:mm AM/PM for all my times. Can someone please help ASAP?