Question

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

比如2020-2-10 14:50；2020-3-15 7:05；2020-1-3 23:59；2020-4-11 5:27；这几个时间内，我要把早晨8:00到12:00,12:00到13:30的筛选出来?

Answer 1

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"))

Answer 2

你可以加个公式计算出小时数，再筛选出大于等于8且小于等于12的，然后再筛选下午的。