excel如何计算复杂工时答:=IF(IF(B1*24<=12,B1*24,IF(B1*24<=13,12,IF(B1*24<=17,B1*24-1,IF(B1*24<=18,16,B1*24-2)))-IF(A1*24<=12,A1*24,IF(A1*24<=13,12,IF(A1*24<=17,A1*24-1,IF(A1*24<=18,16,A1*24-2)))<0,IF(B1*24<=12,B1*24,IF(B1*24<=13,12,IF(B1*24<=17,B1*...
在Excel里计算两个任意日期之间的工时答:C2输入:=ROUND(24*(IF(WEEKDAY(A2,2)<=5,IF(AND(MOD(A2,1)>=8.5/24,MOD(A2,1)<=16.75/24),IF(MOD(A2,1)<=11.75/24,11.75/24-MOD(A2,1)+16.75/24-13/24,IF(MOD(A2,1)<=13/24,16.75/24-13/24,16.75/24-MOD(A2,1))),0),0))+(NETWORKDAYS(A2,B2)-...