Hi there,
I am hoping that someone can help me. I have a task that I would like to accomplish and that is to understand the maximum number of simultaneous calls taking place on our phone system on a daily basis.
I had hoped that our phone system would have some sort of reporting built in to it, but sadly not, it merely outputs a load of data - an entry for every call that took place on the system.
I've included some examples in the attached spreadsheet.
Would some kind person please show me how to write a macro that looks at the entries on the sheet, identifies which calls overlapped, and then produce a total for each day? Just to clarify, if on a given day, there were 2 calls that overlapped in the morning, and then 3 calls that overlapped in the afternoon then I would only be interested in the 3 overlapping calls as I'm trying to understand the maximum number of overlapped/simultaneous calls during a day (i hope that makes sense).
For example, in the spreadsheet I have call logs from 24th June and 25th June, and I would love a macro to generate a report stating:
24/06/2012: 0
25/06/2012: 4
Any help would be hugely appreciated.
Many thanks in advance for even reading this,
AndrewCall_log.xls
Bookmarks