Apologies I'm very very new to excel formulas etc. so please be patient with me </SPAN></SPAN>
I have a spreadsheet which contains raw message stats and need to be able to work out if each message received is within 1 hour SLA however I'm not sure the best way to do this or easiest. In addition to this, I need to only calculate and factor in working days and time.
Below is the data table I have (as described above as raw message stats). You'll see that the first two entries were resolved in well under 1 hour and within our working day and time so not a problem however the third would fail as it was received out of hours so if I need a way to factor out, out of hours time (as GOS for me is based on working days and hours).
My working hours are Monday to Friday 08:00am until 18:00pm.
Any help anyone could give would be massively appreciated.
<TBODY>
</TBODY>
I have a spreadsheet which contains raw message stats and need to be able to work out if each message received is within 1 hour SLA however I'm not sure the best way to do this or easiest. In addition to this, I need to only calculate and factor in working days and time.
Below is the data table I have (as described above as raw message stats). You'll see that the first two entries were resolved in well under 1 hour and within our working day and time so not a problem however the third would fail as it was received out of hours so if I need a way to factor out, out of hours time (as GOS for me is based on working days and hours).
My working hours are Monday to Friday 08:00am until 18:00pm.
Any help anyone could give would be massively appreciated.
Received | Closed | Resolution Time (Secs) |
30/12/2013 17:06:40 | 30/12/2013 17:08:45 | 125 |
30/12/2013 16:59:21 | 30/12/2013 17:03:28 | 247 |
30/12/2013 00:04:02 | 30/12/2013 08:17:17 | 29595 |
<TBODY>
</TBODY>