Calculate Turn Around Time and SLA

[Dnyan]

Hi All,

I want to calculate Turn Around time and SLA for making Tracker. So required VBA Code for this, so please help me.

Below is the Details:

[TABLE="width: 225"]
<tbody>[TR]
[TD="class: xl80, width: 109"]Shift Start Time[/TD]
[TD="class: xl85, width: 116"]08:00[/TD]
[/TR]
[TR]
[TD="class: xl80"]**** End time[/TD]
[TD="class: xl85"]17:00[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 716"]
<tbody>[TR]
[TD="class: xl80, width: 64"]Worktype[/TD]
[TD="class: xl80, width: 64"]TAT[/TD]
[TD="class: xl80, width: 109"]Start Time[/TD]
[TD="class: xl80, width: 116"]Turn Around Time[/TD]
[TD="class: xl80, width: 109"]Completed Time[/TD]
[TD="class: xl80, width: 254"]SLA[/TD]
[/TR]
[TR]
[TD="class: xl80"]ABC[/TD]
[TD="class: xl80"]2 Hours[/TD]
[TD="class: xl80, align: right"]28-07-2017 08:18[/TD]
[TD="class: xl78, align: right"]28-07-2017 10:18[/TD]
[TD="class: xl80, align: right"]28-07-2017 09:25[/TD]
[TD="class: xl78"]How Much Time taken to complete this[/TD]
[/TR]
[TR]
[TD="class: xl80"]BCD[/TD]
[TD="class: xl80"]4 Hours[/TD]
[TD="class: xl80, align: right"]28-07-2017 08:18[/TD]
[TD="class: xl78, align: right"]28-07-2017 12:18[/TD]
[TD="class: xl80, align: right"]28-07-2017 13:32[/TD]
[TD="class: xl78"]How Much Time taken to complete this[/TD]
[/TR]
[TR]
[TD="class: xl80"]CDE[/TD]
[TD="class: xl80"]2 Days[/TD]
[TD="class: xl80, align: right"]28-07-2017 08:18[/TD]
[TD="class: xl78, align: right"]01-08-2017 12:18[/TD]
[TD="class: xl80, align: right"]31-07-2017 10:48[/TD]
[TD="class: xl78"]How Much Time taken to complete this[/TD]
[/TR]
</tbody>[/TABLE]

Want to Automate Turn Around Time and SLA Coloumns,

Also want to highlight SLA cells if its went out of Service Level.

So please help

 

[Dnyan]

Can anyone help me for this!!!