How to calculate Turn Around Time (TAT) considering weekend and working Hours..!

tyrelmiranda 

Oops, too old formula. If to fix it, change in second line

NETWORKDAYS.INTL(...) on

MAX(0, NETWORKDAYS.INTL(...) )

Entire formula will be

=IF(INT(B2)>INT(A2),
  MAX( 0,NETWORKDAYS.INTL(A2+1,B2-1,"0000011",$J$2:$J$3))*8/24 +
  (WORKDAY.INTL(A2-1,1,"0000011",$J$2:$J$3)=INT(A2))*
  (
    $F$2-MEDIAN($E$2,$F$2,MOD(A2,1)) +
    $H$2-MEDIAN($G$2,$H$2,MOD(A2,1))
  ) +
  (WORKDAY.INTL(B2-1,1,"0000011",$J$2:$J$3)=INT(B2))*
  (
    MEDIAN($E$2,$F$2,MOD(B2,1))-$E$2 +
    MEDIAN($G$2,$H$2,MOD(B2,1))-$G$2
  ),
  MIN($F$2,MOD(B2,1))-MEDIAN($E$2,$F$2,MOD(A2,1))+
  MEDIAN($G$2,$H$2,MOD(B2,1))-MAX($G$2,MOD(A2,1))
)

which gives