å
¬å¼å¦ä¸ï¼
=24*(IF(WEEKDAY(A1,2)<=5,IF(AND(MOD(A1,1)>=9.5/24,MOD(A1,1)<=18.5/24),IF(MOD(A1,1)<=0.5,0.5-MOD(A1,1)+5.5/24,IF(MOD(A1,1)<=13/24,5.5/24,18.5/24-MOD(A1,1))),0),0))+24*(IF(WEEKDAY(B1,2)<=5,IF(MOD(B1,1)<=18.5/24,IF(MOD(B1,1)<=13/24,IF(MOD(B1,1)<=0.5,IF(MOD(B1,1)<9.5/24,0,MOD(B1,1)-9.5/24),2.5/24),MOD(B1,1)-13/24+2.5/24),8/24),0))+(NETWORKDAYS(A1,B1)-SUMPRODUCT((WEEKDAY(A1:B1,2)<=5)*1))*8
ä¸æ®µï¼
1ãå¼å§å½å¤©å·¥æ¶
2ãç»æå½å¤©å·¥æ¶
3ãç»ææ¥æåå¼å§æ¥æä¹é´çå·¥ä½æ¥å·¥æ¶
温馨提示:答案为网友推荐,仅供参考