Forum Discussion

Abhishek Shrivastav's avatar
Abhishek Shrivastav
Copper Contributor
Mar 13, 2018

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...
Excel - formulas data worksheet
Formulas & Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 13, 2018

Hi,

 

With data structured like this

the formula could be

=NETWORKDAYS.INTL(F2+1,G2-1,"1111011")*9/24 +
  (INT(G2-1)-INT(F2+1)+1-NETWORKDAYS.INTL(F2+1,G2-1,"1111011"))*15/24 +
 (IF(WEEKDAY(F2,2)=5,$C$3,$C$2)-MOD(F2,1) +
 MOD(G2,1)-IF(WEEKDAY(G2,2)=5,$B$3,$B$2))

I added helper cells for working hours, in general could be hardcoded using TIME() function.

 

Sample is attached.

vickyakhatri's avatar
vickyakhatri
Copper Contributor
Nov 14, 2023

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's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 15, 2023

    vickyakhatri 

    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.

Resources