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,477
    Provided Answers: 11
    we need more info

    what in the cell
    is it datetime or just time

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

    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

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