Using COUNTIF to determine # of employees working each hour

I'm using Excel to schedule employees shifts at my restaurant. Column A is their name, Column B is their start time, Column C is their end time.

I'd like to be able to count the number of employees working during any given hour of the day to assure I've got enough staffing each hour.

I'm thinking it will require a COUNTIF function but I can't figure out how to make it work. I've attached a sample sheet if that helps. Any assistance would be greatly appreciated.

That certainly gets me the number I want but I'm wondering if there's anyway to do it without that intermediate step of the X's. The visual breakdown with the X's gets a bit cumbersome with 35-45 employees. The other issue is ideally I'd like for it to be able to account for half hours. For instance if Susie comes on shift at 9:30am and two other people come on at 9:00am I'd want it to reflect that there's 2.5 hours of labor for that 9am hour slot.

I'd found this on another site and it seemed it might work in my situation but I couldn't make it work.

Problem:
Columns B & C show the times that each of a building's tenants left and returned on a particular day.
We want to calculate the building's occupancy rate at each of the times listed in column E.

Solution:
Use the COUNTIF and COUNT functions as shown in the following formula:
=(COUNTIF($C$2:$C$6,">="&E2)-COUNTIF($B$2:$B$6,">"&E2))/
COUNT($A$2:$A$6)

Hi all. I'm digging up this thread because it's very close to what I'm trying to do in my sheet and don't know the proper Countif formula.

I've attached my dropbox of the sheet
https://www.dropbox.com/s/713q4og4ig...1%29.xlsx?dl=0

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.

Beh162, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Beh162, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.