Results 1 to 8 of 8

percentage of customers reply

Threaded View

MCsam97 percentage of customers reply 08-06-2011, 04:19 PM
JBeaucaire Re: help :( 08-06-2011, 04:23 PM
MCsam97 Re: percentage of customers... 08-06-2011, 04:35 PM
JBeaucaire Re: percentage of customers... 08-06-2011, 04:59 PM
MCsam97 Re: percentage of customers... 08-06-2011, 05:06 PM
JBeaucaire Re: percentage of customers... 08-06-2011, 05:19 PM
MCsam97 Re: percentage of customers... 08-06-2011, 05:36 PM
JBeaucaire Re: percentage of customers... 08-06-2011, 06:25 PM
  1. #1
    Registered User
    Join Date
    08-06-2011
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    4

    percentage of customers reply

    hey, i need help with my work report, can't find right formula for it.

    so here is the thing, i work in a blog where customers ask questions and i have to answer it during exact time, as below

    from 7:00am till 3:00pm i should answer within 1 hour
    from 3:00pm till 10:00pm i should answer within 3 hours
    from 10:00am till 7:00am i should answer within 10 hours

    so for sure I'm not replying all customers at same time, i need to calculate the percentage of the time to know my KPI.

    i'll put example if it needed to help with finding the formula:

    3/14/11 8:37 - 3/14/11 8:57 0 Days, 0 Hrs, 20 Min,
    0 Sec

    3/14/2011 10:03 - 3/14/2011 10:22 0 Days, 0 Hrs, 19 Min,
    0 Sec

    3/14/11 8:37 - 3/15/11 10:57 1 Days, 2 Hrs, 20 Min,
    0 Sec (so this one i answered the customer late)

    help !!!!
    Attached Files Attached Files
    Last edited by MCsam97; 08-06-2011 at 06:49 PM.

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