Concurrent Calls Formula

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

Thanks, Now is there an easy formula to find out the max. So I need a formula that will count the MAX occurrences of "Yes" and stop the count once the pattern is broken,

Example

Yes
Yes
Yes
-
-
-
Yes
Yes
Yes
Yes
-
-

I want the answer to be 4 as this is the most Yes's without a break.

Thanks

DJ

Thanks, Now is there an easy formula to find out the max. So I need a formula that will count the MAX occurrences of "Yes" and stop the count once the pattern is broken,

Example

Yes
Yes
Yes
-
-
-
Yes
Yes
Yes
Yes
-
-

I want the answer to be 4 as this is the most Yes's without a break.

Thanks

DJ