I have a a schedule I would like to count how many people are scheduled during a certain time frame.

2:45 AM - 11:30 AM
5:45 AM - 2:30 PM
8:45 AM - 5:30 PM
8:45 AM - 2:30 PM
8:45 AM - 5:30 PM
8:45 AM - 7:30 PM
6:45 PM - 3:00 AM

Column A is the "in" time and Column C is the "out" time. (Column B is the "-")

I would like to count how many people are scheduled at 3pm (answer is 3)

I'm thinking I will need to use a sumproduct and an OR statement for this.

Any help would be appreciated!! Thank you!