Hi Guys,
I am trying to include another time slot for the formula I wrote with some digging online but now I am not sure how to change it to two slots.
=(NETWORKDAYS(J3,K3,Holidays!$C$2:$C$50)-1)*($O$2-$N$2) + IF(NETWORKDAYS(K3,K3),MEDIAN(MOD(K3,1),$O$2,$N$2),$O$2)-MEDIAN(NETWORKDAYS(J3,J3)*MOD(J3,1),$O$2,$N$2)
Above is the formula that one calculates the Turn around time for me from 08:00 AM EST to 17:00 PM EST but now I want to add one more to that which is 08:00 PM EST to 05:00 AM EST so basically time in between should not come under tat
I am trying to include another time slot for the formula I wrote with some digging online but now I am not sure how to change it to two slots.
=(NETWORKDAYS(J3,K3,Holidays!$C$2:$C$50)-1)*($O$2-$N$2) + IF(NETWORKDAYS(K3,K3),MEDIAN(MOD(K3,1),$O$2,$N$2),$O$2)-MEDIAN(NETWORKDAYS(J3,J3)*MOD(J3,1),$O$2,$N$2)
Above is the formula that one calculates the Turn around time for me from 08:00 AM EST to 17:00 PM EST but now I want to add one more to that which is 08:00 PM EST to 05:00 AM EST so basically time in between should not come under tat
