Visualize list of calls in csv file to learn max # of simultaneous calls

bigbangtech
bigbangtech used Ask the Experts™
on
I have a csv file with a list of telephone calls, with columns for start time, end time, and duration for 30 days. I need to figure out how calls overlapped, to see what was the highest amount of simultaneous calls, and average amount of simultaneous calls by day, and for the month.

==========
Prior related question: http:Q_28533850.html
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Microsoft Excel Expert
Top Expert 2014
Commented:
here is the file.

see if this is exactly what you are looking for.
ee.xlsb
Top Expert 2014

Commented:
@ProfessorJimJam

Where did you get the workbook?  Is there a prior related question that we should know about?
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
@aikimark

i recalled a similar question that Glenn and I, we have provided solution in month of October

the reference link is here http://www.experts-exchange.com/Software/Office_Productivity/Q_28533850.html

Author

Commented:
I will review the excel sheet and get back next week.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial