在EXCEL中如何用公式统计加班时数?答:在D2中输入或复制粘贴下列公式 =IF(OR(RIGHT(B2)={"六","日"}),C2,IF(C2>8,FLOOR(C2-8,0.5),0))或 =IF(OR(RIGHT(B2)={"六","日"}),C2,(C2>8)*FLOOR(C2-8,0.5))下拉填充
求excel,周末加班,平时加点,总工时,计算公式?答:AG5单元格输入:=IF(SUM(B5:AF5),SUM(B5:AF5),"")AH5单元格输入:这是一个数组公式,以三键同时按下:Ctrl+Shift+回车 结束公式输入 =IF(AG5="","",SUM(IF(E5:I5:L5:P5:S5:W5:Z5:AD5>8,E5:I5:L5:P5:S5:W5:Z5:AD5-8),B5:D5,J5:K5,Q5:R5,X5:Y5,AE5:AF5))输入...