Results 1 to 15 of 15

Complex Call Centre Data

Threaded View

wolfep93 Complex Call Centre Data 03-10-2014, 02:12 PM
Alf Re: Complex Call Centre Data 03-11-2014, 03:05 AM
wolfep93 Re: Complex Call Centre Data 03-12-2014, 10:25 AM
wolfep93 Re: Complex Call Centre Data 03-12-2014, 10:29 AM
Mazzaropi Re: Complex Call Centre Data 03-12-2014, 11:34 AM
Alf Re: Complex Call Centre Data 03-12-2014, 12:13 PM
wolfep93 Re: Complex Call Centre Data 03-12-2014, 02:12 PM
wolfep93 Re: Complex Call Centre Data 03-12-2014, 02:51 PM
Mazzaropi Re: Complex Call Centre Data 03-12-2014, 11:26 PM
wolfep93 Re: Complex Call Centre Data 03-13-2014, 09:04 AM
Peter.M Re: Complex Call Centre Data 03-13-2014, 11:19 AM
newdoverman Re: Complex Call Centre Data 03-13-2014, 11:32 AM
Mazzaropi Re: Complex Call Centre Data 03-13-2014, 11:55 AM
Mazzaropi Re: Complex Call Centre Data 03-13-2014, 12:03 PM
newdoverman Re: Complex Call Centre Data 03-13-2014, 02:12 PM
  1. 03-12-2014, 11:34 AM #5
    Mazzaropi is offline
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Complex Call Centre Data

    wolfep93, Good afternoon.

    Scenario:
    .-----A------|-----B----
    1..start time.|.stop time
    2.....8:15.....|...8:17...
    3.....8:25.....|...8:31...
    4.....8:33.....|...8:37...
    5.....8:52.....|...8:56...
    6.....9:10.....|...8:16...
    7.....9:17.....|...8:23...

    Try to do:
    D1 = 08:20 - Limit - Start time
    E1 = 09:00 - Limit - Stop time

    F1 --> =COUNTIFS(A2:A7,">="&D1,B2:B7,"<="&E1)

    Is it what you want?
    I hope it helps.
    Last edited by Mazzaropi; 03-12-2014 at 11:47 AM. Reason: typo
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Call centre quality assurance assessment tool. calculating scores by selecting yes or no
    By Chaos247 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-06-2021, 09:06 AM
  2. Call Centre/Erlang Formula Problems
    By blackhand2010 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2014, 06:30 PM
  3. Complex formula help needed - counting visits if admit date is within 18 months of call
    By jcmantaray in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2013, 09:07 PM
  4. Tracking Call Centre Metrics as a Race
    By Kwelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2010, 02:48 AM
  5. trouble call data from one cell into the centre of a block of text in another cell
    By technophobe in forum Excel General
    Replies: 2
    Last Post: 10-12-2008, 01:34 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1