excel筛选出符合某个时间段的时间?

B2:=IF(AND(HOUR(A2)=12,MINUTE(A2)=0),OK,IF(AND(HOUR(A2)=8,HOUR(A2)12),OK,NOK))C2:=IF(AND(HOUR(A2)=12,MINUTE(A2)=0),NOK,IF(OR(AND(HOUR(A2)=13,MINUTE(A2)=30),AND(HOUR(A2)13,HOUR(A2)=12)),OK,NOK))