sla

Hi All, Excel version – 2010 I’m trying to calculate ticket incident duration in minutes for issues that occur in an environment with non-standard business hours. Depending on the location the incident occurs the hours in the “business day” vary and need to accommodate the total duration of...

I need some help because I'm not highly skilled at creating complex formulas in Excel. I'm looking for a formula that will help us determine if there is an actual difference in response between the two different SLA goals we have. The two different plans we have are: N = Mon-Sun 08:00 - 23:00...

Greetings, I have yet to come across anything quite like this and I will try to be as thorough as possible... I have been given a sheet of raw data that spans 6 months of time, consisting of 11 columns and 4000+ rows. I am focused on 4 very specific columns: "Ticket Priority" "Ticket...

Hello everyone First time poster so please be gentle! on my spreadsheet i have the following fields :- <colgroup><col span="2"><col><col><col></colgroup><tbody> Date and Time Received Date and Time Sent Time Taken Number of Hours Within SLA? 04/03/2013 15:38 20/03/2013 13:39 15 days 22:00...

Hi Guys, I'd like to know if there is a way to extract date and time with VBA based on an IF from a different cell, I can use =if(A1="Yes",Now(),""), however this formula will change the date and time every time the spreadsheet is opened or modify and I need the original date and time to...

Hi, I need to calculate an SLA. I have 1 column called 'Date/Time Requested' containing the time and the date together, as in: dd/mm/yy hh:mm I also have a second column called 'Date/Time Completed' containing the date and time in the same format as above. I need a macro that compares the...