Scheduling employees - Countif formula building

im trying to figure out the proper countif formula for a few sheets I'm working on

Excel file is in post #3

The formula is needed in the Lines tab B8:B38. The range is in the schedule tab B8:B33 for in time. C8:C33 out time.

In the schedule tab I have Cashier's schedules I want to be able to have their schedules tally in the Lines tab. So if there is a cashier working 8-4:30 I want there to be a "1" in the lines sheet from 8:30AM to 4:45pm (Always stops 15 minutes before the end of their shift in this case stop at 4:30). That would continue for every time listed.

I have this formula in there and it seems to work but I know it's very basic to that first time, not sure what you would do for the next increment of time since it will need to include the previous time in it's count: =COUNTIF(Schedule!B8:B33,"8:30")

And how do I get it to fill down stopping at 4:30 for the 8a-5p example I used above. Obviously I need it for the whole range but I want to try to understand it first. Thanks!

Not all members are willing - or able - to download files from file-hosting sites, please upload here to the forum

So you have 4 cashiers working from 10:00 to 18:30? So, B13 to B32 in Lines is filled with 4?

You are getting comparisons that won't work. A8:A38 of the Lines sheet are not all times. I.E. 10 is not the same as 10:00 AM. Time is a decimal fraction of a day. Days are integers such as 10 and will always be greater than fractions of a day. 10:00 AM is equivalent to 10/24 (ten 24ths of a day) or in decimal 0.416666666666667. The same is true for all the rest of the integers / whole numbers in that range....11, 12, 1, 2, 3........

Excel is interpreting and evaluating the rest of your times properly.

Also in A21 for example you have 1:30 where the pattern suggests you want 1:30 PM, but looking in the formula bar it shows 1:30 AM.

If those issues are taken care of in that range you'll have a much better chance of getting a formula to work the way you want it to.