+ Reply to Thread
Results 1 to 2 of 2

Report Suggestions?

  1. #1
    Registered User
    Join Date
    07-24-2009
    Location
    Hollywood, Florida
    MS-Off Ver
    Excel 2003
    Posts
    6

    Report Suggestions?

    I am in the IT department of a call center. We can import the workers phone records into Excel from the VoIP manager. What we want to find are gaps between calls and I was wondering if someone could point me in the right direction.

    the data is:

    Time, phone number, call duration

    each call is a separate row.

    So I'd like to be able to use some way to go down the calls and find a gap. Let's say:

    3:00, 555-1212,3:47
    3:25, 555-2345, 2:45
    3:55, 555-4567,1:03

    then we have an employee with long gaps between calls. With all the noise in a large call center someone goofing off can remain under the radar if they look like they are doing something.

    So can it be done in Excel or a 3rd party reporting tool?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Report Suggestions?

    Something like this?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1