Dnyan
Board Regular
- Joined
- Mar 25, 2010
- Messages
- 90
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:
<tbody>
</tbody>
<tbody>
</tbody>
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
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:
Shift Start Time | 08:00 |
**** End time | 17:00 |
<tbody>
</tbody>
Worktype | TAT | Start Time | Turn Around Time | Completed Time | SLA |
ABC | 2 Hours | 28-07-2017 08:18 | 28-07-2017 10:18 | 28-07-2017 09:25 | How Much Time taken to complete this |
BCD | 4 Hours | 28-07-2017 08:18 | 28-07-2017 12:18 | 28-07-2017 13:32 | How Much Time taken to complete this |
CDE | 2 Days | 28-07-2017 08:18 | 01-08-2017 12:18 | 31-07-2017 10:48 | How Much Time taken to complete this |
<tbody>
</tbody>
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
Last edited: