=if(A7,if(and(hour(A7+F$5)>8,(hour(A7+F$5)<19)),A7+F$5,workday.intl(int(A7),1,"0000001")+hour(A7+F$5-$B$1)/24+minute(A7)/1440),"") FOR 1 HOUR TAT
=if(F7,if(G7<>"",if(G7>F7,G7-F7,""),$A$1-F7),"") FOR DELAY
=if(F7,if(and(hour(F7+K$5)>8,(hour(F7+K$5)<19)),F7+K$5,workday.intl(int(F7),1,"0000001")+hour(F7+K$5-$B$1)/24+minute(F7)/1440),"") FOR 3 HOUR
=if(K7,if(L7<>"",if(L7>K7,L7-K7,""),$A$1-K7),"") DELAY
=if(K8,workday.intl(int(K8),0,"0000001",)+18/24,"") PLAN
=if(O8,if(P8<>"",if(P8>O8,P8-O8,""),$A$1-O8),"") DELAY
No comments:
Post a Comment
THANKS FOR YOUR SUPPORT