- last edited on
I need formula for Trun around Time (TAT) For Incident.
For Ex. Start Date Time : 25/2/2018 10:00 AM
End time : 28/2/2018 6:00 PM
Manual TAT calculation is :- 53:00
Working hours for Sat to thu is 7:00 Am to 10 Pm & For Friday is 9:30 AM to 6:30 PM
So I need the Formula as per the Working hours and all days which calculate TAT.
So please help me thank you
With data structured like this
the formula could be
I added helper cells for working hours, in general could be hardcoded using TIME() function.
Sample is attached.
Could you please help me out to calculate TAT between particular time Windows.