Is it possible to get a graph or chat of colliding time stamps for phone calls?

Hi Toronto,

Welcome to the forum...

Please find attached workbook for your reference and confirm if this is what you were looking for.

Originally Posted by adhawan06

Hi Toronto,

Welcome to the forum...

Please find attached workbook for your reference and confirm if this is what you were looking for.

Thanks for this. It is close but not really what I want.
X-Axis should be time which is correct. Y-Axis should be number of simultaneous calls which can be from 1 - 100. For example at 10:11 there should be a bar showing 2 calls going on. This is because the call that started at 10:10 is still going on while the next call came in at 10:11 so there is an overlap and there are two channels going on at 10:11. At 10:10 there was only one call going on. None of your other time logs overlap so I can not give those as examples. But basically, I want to show the highest number of calls that happened at one single time during the day.

Please refer the updated attachment...and let me know if this is what you were looking for..

Originally Posted by adhawan06

Please refer the updated attachment...and let me know if this is what you were looking for..

Thanks again. This is VERY close now. However, two issues are remaining:

1- We still do NOT see the overlap of Row 2 (10:10 start of call and 10:12:25 end of call - 145 seconds duration) and Row 3 (10:11 start of call and 10:12 end of call - 60 seconds duration of call); Therefore, there is 2 calls going on between 10:11 and 10:12 so we should have two calls showing there. I think X-axis can be a general 24 hour time-line value rather than grabbing it's values from column C.

2- We should only see one bar for 13:00 record or for 15:00. The correct number of 2-calls is displayed but in two different timelines. It should be only one 13:00 so I think this is the same as I mentioned in point #1.

Y-axis is now good. I think X-axis needs work. Probably some logic / calculation should put into the value to find overlaps before they are put on the graph. Maybe something like: =C2+TIME(0,0,D2) and then compare for other over laps and create a whole new column?

***Note, we also do not need to show the phone numbers in chart but date can be useful. Maybe the dataset can be modified to cover only a 24 hour period so it's 01/01/2014 for the date to get this working and then focus on a wider range like a month?!

Thanks,