在E2中输入或复制粘贴下列公式
=IF(COUNTBLANK(F2:I2)=4,"缺勤",IF(OR(F2<>"",H2<>""),CHOOSE((F2-"8:45">0)+(H2-"13:45">0)+1,"","迟到1次","迟到2次"),"")&IF(OR(G2<>"",I2<>""),CHOOSE((G2-"12:00"<0)+(I2-"17:30"<0)+1,"","早退1次","早退2次"),""))
下拉填充
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024