1.时间格式的问题,如8:30,excel会认为是从第8列到第30列2.8:308.5,H4<=9)3.把8:30,9:00,17:30,18:00分别录入A1,A2,A3,A4,单元格设成时间。公式改为IF(AND(AND(H4>A1,H4<=A2),I4>=A4),"A",IF(AND(H4<=A1,I4>=A3),"B",IF(AND(H4>A2,I4>=A4),"C","异常")))