Excel如何设定时间的条件函数,包含If,and,or答:迟到:= IF(F3>TIME(9,30,0),F3-TIME(9,30,0),IF(H3>TIME(14,0,0),H3-TIME(14,0,0),IF(F3<=TIME(9,30,0),0))早退:= IF(((I202-F202)<TIME(4,0,0)),0.5,IF((I202-F202)>TIME(4,0,0),1)))周末加班= IF(((I202-F202)<TIME(4,0,0)),0.5,IF((I202-F2...