虽然公式繁一点，还是帮你一下吧！=IF(OR(AND(TEXT(A1,"hh:mm")>TEXT("8:00","hh:mm"),TEXT(A1,"hh:mm")TEXT("16:30","hh:mm")),"迟到早退","正常")
