Good Morning,

I need to know the MAX that calls came into my call centre at the same time (Within 30 second range) but also want to include lines being used at the time.

Data Set

Column A = Call Start Time
Column B = Call End Time
Column C = Call Duration

So for example

Start - 08:45:00 -Ends 09:01:10
Start - 09:00:00 - Ends 09:01:00
Start - 09:00:30 - End 09:32:00
Start - 09:02:00 - End 09:02:30

I want the results to be 3 for the example above.

Regards

DJ