1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SLA Setup in Excel

Discussion in 'Software' started by Chopperchand, Oct 10, 2012.

  1. Chopperchand

    Chopperchand Nibble Poster


    I am trying to setup a SLA spreadsheet with data from our helpdesk system.

    Cell A – 10/10/2012 08:00
    Cell B - 10/10/2012 15:00

    1. Working hours 08:00 to 18:00 weekdays only
    2. Calls are logged at anytime during day/night

    I have a formula which I got of the internet


    Which works if the days are in the same month and within the above time frame

    What I am look for help with is…

    I need to work out the hours open if the call is logged on the last day of the month and the next working day is start of the next month(As this can be within the SLA) and also how to stop it from calculating outside the working hours.

    As I am not that clued up on Excel was wondering if anyone could point me in the correct direction. hope this makes sense.

    Thank you
    WIP: MCSA Sql Server 2012

Share This Page