Hello, I need some assistance. I am trying to calculate how many people are present in a given time interval (15 minutes). I have listed the person, start time, end time, lunch start time, lunch end time, Breaks (2) start & end times all separate. On a separate sheet I have a set of times 5am - 5pm in 15 minute intervals. I listed the start & end times for each of these as well. I am trying to come up with a formula that will see how many people are present at that given time. My thoughts are countifs but I am seeing this is very difficult. Any assistance would be helpful (want to see how many employees are available at any given time). Thanks!!