I need to figure out how to write a formula to calculate how many agents are working during any given time segment. This is an example of what the sheets I'm working off of look like, but at work each chart snippet is full size and encompasses a week, with the time slots covering 12 AM- 11:30 PM, and is on a separate spreadsheet in the same workbook. I'm trying to write a formula to do this, since counting by hand is prone to error.
agent calculation.xlsx