I have a scheduling spreadsheet that I created and need to be able to count the number of occurrences by hour between the In and Out times for each employee. E.g. How many occurrences are there between the In and Out times that = 8:00 AM, 9:00 AM etc. I want to get a count of how many employees are scheduled for each hour of the day that I can use in a line/bar graph.

Schedule.PNG

Employee In Out
John Doe 7:00 AM 3:00 PM
Jane Doe 9:00 AM 4:30 PM
Bill Smith 12:00 PM 8:00 PM
Sue Jones 8:00 AM 4:00 PM