找出12:00-13:00之间的时间 (10639)


E2=IFERROR(INDEX(MID(A2,{1,7,13,20},5),MATCH(,0/("12:00"-MID(A2,{1,7,13,20},5)<0)/("13:00"-MID(A2,{1,7,13,20},5)>0),)),"无")


另解=IFERROR(MID(A2,-LOOKUP(,-FIND(TEXT(13/24-ROW($1:$59)/1440,"HH:MM"),A2)),5),"无")


留言