I’m new here and hoping to get some assistance.
For background, I work in finance and look after a small but busy team. The work we do is based on emails received by customers which we then have to fulfill. We have SLA’s for our different work queues. We don’t work weekends or public holidays and our hours of operation is from 9am – 5pm (which is when the SLA clock stops).
What do I need?
Based on the above information, I need a formula or way of working out the TAT (Turnaround time).
Date & Time Received Date & Time closed
24/08/2020 9:15 26/08/2020 11:30
21/08/2020 12:30 24/08/2020 6:30
Example 1. The turnaround time is 18 hours and 15 mins
Example 2. The turnaround time is 4 hours 30 minutes. This is because we received the file on a Friday and closed the case on the following Monday at 6:30am (clock does not start until 9am).
Hope this makes sense and hope I’ve added the post in the right section. I do have a copy of the file with dummy data.
Sean aka BI_Noob