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 the sheet if that helps.

CountHours.xls29 KB
CountHours-ExcelExperts.xls52 KB
Nick's picture

Count employees

hi.. I have attached a solution to your original post.

I don't agree with your numbers... I have assumed that when a person's shift ends, they go home immediately!


Oops, you were right.  I

Oops, you were right.  I changed some of the starting times after I manually calc'd my "real numbers".  Good catch!


Thanks for the help!