Timeline / formula to determine number of simultaneous calls

[rleash]

I have a list of phone calls placed during the past month, with the start time, end time, and duration of the call. These calls were placed from multiple phone lines, so there is overlap in the timing, but I don't have what line the call was made from. I want to find out the maximum number of lines that were in use at any given time. It would also be great to see how many times that maximum number was reached. It seems like there must be a way in excel to do this.. either with a visual timeline, or something. Any ideas?

[AliGW]

There probably is, but first, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[rleash]

While I was trying to create for you what I was looking for and manually plugging in values, and I think I solved my own problem. But just to help others in the future, here's what I had:

Call Start Time Call End Time
7/21/2016 10:25 7/21/2016 10:54
7/21/2016 10:32 7/21/2016 11:01
7/21/2016 11:17 7/21/2016 12:38
7/21/2016 11:20 7/21/2016 12:18
7/21/2016 11:53 7/21/2016 12:32

And I wanted a 3rd column which showed the number of lines in use at the time the call came in. So I sorted column A by time, then used this formula (this would be in cell C4, since C2 & C3 would be different):

=COUNTIF(B$2:B3,">" & A4)+1

So I end up with something like this:

Call Start Time Call End Time # lines in use
7/21/2016 10:25 7/21/2016 10:54 1
7/21/2016 10:32 7/21/2016 11:01 2
7/21/2016 11:17 7/21/2016 12:38 1
7/21/2016 11:20 7/21/2016 12:18 2
7/21/2016 11:53 7/21/2016 12:32 3