Quote Originally Posted by joris moerings View Post
Hi, see if this formula does the trick in calculating the TAT:
=(NETWORKDAYS(B2,F2)-1)*("18:30"-"09:30")+IF(NETWORKDAYS(F2,F2);MEDIAN(MOD(F2,1),"1 8:30";"09:30"),"18:30")-MEDIAN(NETWORKDAYS(B2,B2)*MOD(B2,1),"18:30","09:30 ")

The formula to check f TAT is realized is:=IF(G2*24>4,"No","Yes")

Hi Joris,

thanks for help but this formulla is not working, giving #Value error.

Regards,
Pramod Kumar