+ Reply to Thread
Results 1 to 5 of 5

Call Rate Formula

  1. #1
    Registered User
    Join Date
    04-28-2017
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    3

    Call Rate Formula

    Hi there. I need a formula to show me, for example, if we receive 2500 calls with a handling time of 450 seconds per call, how many calls could we have received if our average handling time was 350.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,735

    Re: Call Rate Formula

    The time taken to handle those 2500 calls is 2500 * 450 seconds, so you could handle these many calls:

    2500 * 450 / 350

    if the time taken was only 350 seconds.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-28-2017
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    3

    Re: Call Rate Formula

    That worked perfectly. Thank you.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,735

    Re: Call Rate Formula

    You're welcome.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  5. #5
    Registered User
    Join Date
    04-28-2017
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    3

    Re: Call Rate Formula

    That's done. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Take rate formula or initial sales rate
    By mlopez60120 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2016, 09:43 AM
  2. [SOLVED] Rate per call based on tiered pricing schedule
    By sarahcombs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2016, 09:28 PM
  3. Replies: 11
    Last Post: 02-22-2016, 02:39 PM
  4. Determining answer rate for calls in call center
    By Paulyzee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2015, 08:19 AM
  5. Replies: 1
    Last Post: 05-16-2014, 10:10 AM
  6. Replies: 1
    Last Post: 02-28-2014, 02:31 AM
  7. [SOLVED] Real RATE of return using =RATE illusive, inflation adjusted inflo
    By Pro - Land in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-01-2005, 12:05 AM

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