Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2015
    Posts
    3

    Post Unanswered: Looking for an formula for my report

    Hi,

    I am working on the SLA report. My process is about ticket based. If I am receiving an critical ticket, I have to response within 30 minutes and I have to resolve it within 4 hours for weekdays, if ticket comes on weekend, I have to response within 2 hours, and I have resolve within 8 hours. For high priority ticket, response time is 45 mins, resolution time is 8 hours for weekdays and no time limit for weekend. For Medium priority ticket, response time is 60 mins, resolution time is 2 business days and no time limit for weekend. For low priority ticket, response time is 60 mins, resolution time is 5 business days and no time limit for weekend. I have captured all the times. The thing is that I need to specify the response and resolution SLA separately for all the priorities. Could you please share me the formula for this????

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sonds liek you need to be thinking of using a database such as Access to do this sort of thing.....
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2015
    Posts
    3

    Post Looking for an formula for my report

    I need to do this in MS excel. Please provide me the formula. If possible, is it done by if functions in excel?

  4. #4
    Join Date
    Apr 2015
    Posts
    3

    Exclamation

    It would be really useful, if I get this done within 20 minutes. I am in hurry. Could you please help me to complete it.

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    we need more info

    what in the cell
    is it datetime or just time

    why just try =[cellADDRESS]-NOW()
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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