Forum Discussion
Abhishek Shrivastav
Mar 13, 2018Copper Contributor
Formula for Trun Around Time (TAT) For incident No Weekend
Hi All,
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 hour...
vickyakhatri
Nov 14, 2023Copper Contributor
SergeiBaklan I am working on a sheet where I need to calculate the turn-around time. I applied the network.intl formula and getting the number days we took for deliveries.
However, the number of days getting calculated is 2 days (and the enquiry days is 13th and we shared the resume on 14th). can you please help
SergeiBaklan
Nov 15, 2023Diamond Contributor
NETWORKDAYS.INTL counts both start and end days, you need to deduct one. Perhaps you may share the sample what exactly and how you calculate.