Tracking tasks inside/outside SLA

**Steven2013** · 05-25-2013, 05:16 AM

We receive several of the same tasks in to the department on a daily basis. The SLA is that each task received is completed with 48 hours. I need to track when a task came in, when it was completed and if it was completed within or over the SLA. For example if we receive 20 tasks on a Monday I need to show how many we're completed by the Tuesday and how many we're carried over to the Wednesday and outside of the SLA. Any ideas would be greatly appreciated as I'm at a dead end...

**nathansav** · 05-25-2013, 06:08 AM

Please see attached

**Spencer101** · 05-25-2013, 07:05 AM

An adapted version of a very simple SLA tracker I use at work.

Hopefully it fits your needs, but easily adapted if not.

**Steven2013** · 05-25-2013, 08:46 AM

That's great! Thank you so much - I'm pretty new to this, but what you have shown me makes sense.

I appreciate you taking the time to do this

Is there anyway that another spreadsheet could also track different tasks coming in to the department all with the same 48 hour SLA. For example if on a Monday 10 of 'Task A', 5 of 'Task B' and 2 of 'Task C' are received is there a way of tracking the progress of each so that their SLA can be viewed in the same way as the first spreadsheet?

Once again your help is greatly appreciated

**Spencer101** · 05-25-2013, 08:57 AM

I'm not sure I completely understand what you require with this.
Could you mock something up and include notes of what you need to achieve and where that information will come from?

I can hopefully pull something together for you from that.

S.