Excel 2007 : Service Level Agreements

see: http://www.excelforum.com/excel-2007...ench-mark.html

Very helpful!!! I have a question regarding the items with:
- start times before the Start of the day -the SLA required end time should not begin until 8:00am
For example:
1/19/2010 6:48am returns 1/19/2010 10:48am but should be 1/19/2010 12:00pm since the start of our day is 8:00am. It gives the analyst the full 4 hours to work on the ticket.

-Likewise with the tickets created after hours on a particular day should not have the SLA required time begin until 8:00am the next day
-And, tickets with SLA of next business day should show the max time: next day 5:00pm [is that possible?]

I have included your spreadsheet with my changes.

Thank you!

KJN

Just to clear up a few things

-- You should only be entering values in the yellow cells - the green cells should be formulae.

-- There is an error in the formula for Col D - all down to a missing $ (!) ... the formula for D2 should read:

Please Login or Register  to view this content.

-- You have moved the holidays range to another sheet which is fine but you need to modify the named range accordingly - presently _Holidays refers to Sheet1 rather than to the new range on Sheet2.


With the above corrections you should find that if you enter:

1/19/2010 06:48 into A6 - D6 will become 1/19/2010 08:00 and E6 in turn 1/19/2010 12:00


On a final note - though I linked to the other thread for reference please ensure you post questions into your thread only - your prior post has been moved back to this thread.