求用Excel计算加班时间和迟到时间的公式答:E2 =IF(AND(WEEKDAY(C2)<=5,DAY(C2)-DAY(C3)=0),IF(HOUR(C2)<9,"未迟到","迟到"),IF(AND(WEEKDAY(C2)<=5,DAY(C2)-DAY(C3)<>0),"",IF(AND(WEEKDAY(C2)>5,DAY(C2)-DAY(C3)=0),IF(HOUR(C2)<9,"未迟到",IF(HOUR(C2)>=10,"迟到",IF(AND(HOUR(C2)=9,(30-MINUTE...