Results 1 to 2 of 2

Thread: Measuring Wait Time

  1. #1
    Neophyte GVitalion's Avatar
    Join Date
    Aug 2019
    Posts
    1
    Articles
    0
    Excel Version
    Excel 2016

    Measuring Wait Time



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello community,

    I'm working in a ranking for a call center and I'm measuring certain KPIs. One of them is "Wait Time" that an agent has during a call.

    This is the formula I'm using to measure "Wait Time" which practically consists of: The less time an agent has of "Wait Time", the greater the percentage obtained in this metric, being the maximum percentage "25%".

    The percentage obtained will obviously be obtained as long as the agent fulfills the established goal "F26" being "B26" the number obtained by the agent.

    This formula what it does is to grant more percentage the smaller is the "Wait Time".

    What I want this formula to do is that if the value obtained by the agent (B26) is greater than (F26), then start decreasing 25% from that moment.

    Code:
    =IFERROR(IF(COUNT(B26)<1,"-",(IF(OR(B26="-",B26<=0%),25%,IF(B26>F26,0%,25%-(B26-0%)/(F26-0%)*25%)))),"-")
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,621
    Articles
    0
    Excel Version
    O365
    How about this?

    Code:
    =IFERROR(MAX(MIN(25%-(B26-F26)/F26*25%,25%),0),"-")

Posting Permissions

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