Forum Discussion

R6R's avatar
R6R
Regular Visitor
5 years ago

How to Calculate TAT

Hi Leads,   How to calculate the TAT between received date and closed date excluding the weekends and holidays. Please help me on this.
R6R's avatar
R6R
Regular Visitor
5 years ago

Thank you I am getting the TAT excluding the Weekends, however could you please help me how to include the holidays in to this, I have the sample data set, but unable to upload here, hence pasting it below. I have to consider weekends and holidays which are 01/01/2021 and 1/26/2021. 

Ticket#Recived DateCustomer NameClosed DateClosed By
12301-01-2021Ajith03-01-2021Rajesh
23402-01-2021Rajith04-01-2021Rajesh
34503-01-2021Santhosh05-01-2021Rajesh
45604-01-2021Jovan06-01-2021Rajesh
56705-01-2021Visin07-01-2021Rajesh
67806-01-2021More08-01-2021Rajesh
78907-01-2021Atul09-01-2021Rajesh
90008-01-2021Vysakh10-01-2021Rajesh
101109-01-2021Sayal11-01-2021Rajesh
112210-01-2021Sunil13-01-2021Rajesh
123311-01-2021Divya 14-01-2021Rajesh
134412-01-2021Veena15-01-2021Rajesh
145513-01-2021Raji16-01-2021Rajesh
156614-01-2021Saji17-01-2021Rajesh
167715-01-2021Adith18-01-2021Rajesh
178816-01-2021Diya19-01-2021Rajesh
189917-01-2021Rohan21-01-2021Rajesh
201018-01-2021Ajith22-01-2021Rajesh
212119-01-2021Rajith23-01-2021Rajesh
223220-01-2021Santhosh24-01-2021Rajesh
234321-01-2021Jovan25-01-2021Rajesh
245422-01-2021Visin26-01-2021Rajesh
256523-01-2021More27-01-2021Rajesh
267624-01-2021Atul28-01-2021Rajesh
278725-01-2021Vysakh29-01-2021Rajesh
289826-01-2021Sayal30-01-2021Rajesh
300927-01-2021Sunil29-01-2021Rajesh
312028-01-2021Divya 30-01-2021Rajesh
323129-01-2021Veena31-01-2021Rajesh
334230-01-2021Raji01-02-2021Rajesh
345331-01-2021Saji02-02-2021Rajesh
356401-02-2021Adith03-02-2021Rajesh
367502-02-2021Diya04-02-2021Rajesh
378603-02-2021Rohan05-02-2021Rajesh
389704-02-2021Ajith06-02-2021Rajesh
400805-02-2021Rajith07-02-2021Rajesh
411906-02-2021Santhosh08-02-2021Rajesh
423007-02-2021Jovan09-02-2021Rajesh
434108-02-2021Visin10-02-2021Rajesh
445209-02-2021More11-02-2021Rajesh
456310-02-2021Atul12-02-2021Rajesh
467411-02-2021Vysakh13-02-2021Rajesh
478512-02-2021Sayal14-02-2021Rajesh
489613-02-2021Sunil15-02-2021Rajesh
500714-02-2021Divya 16-02-2021Rajesh
511815-02-2021Veena17-02-2021Rajesh
522916-02-2021Raji18-02-2021Rajesh
534017-02-2021Saji19-02-2021Rajesh
545118-02-2021Adith20-02-2021Rajesh