We help IT Professionals succeed at work.

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

84 Views
Last Modified: 2014-12-22
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

Microsoft Excel Expert
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
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
CERTIFIED 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 https://www.experts-exchange.com/Software/Office_Productivity/Q_28533850.html

Author

Commented:
I will review the excel sheet and get back next week.
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.