求助解决多条件判断时间

宁两好饱

判断订单提交时间是否在上播时间内。要求订单提交时间前半部分要和上播时间前半部分相等，订单提交时间后半部分时间要求在上播时间之间。

良良

C2=IF(COUNT(VDB(,,(LEFT(B$2:B$7,FIND(" ",B$2:B$7)-1)+MID(B$2:B$7,FIND("-",B$2:B$7)+1,5))%%,(LEFT(B$2:B$7,FIND(" ",B$2:B$7)-1)+MID(B$2:B$7,FIND("-",B$2:B$7)-5,5))%%,A2%%)),"是","否")，三键，下拉。

宁两好饱

用vba的方法试试了，最后筛出来的结果是2886个存在区间的，也不敢确定对不对。求助各位函数大神集思广益

ww87725244

=IF(SUM(N(INT(A2)=--LEFT($B$2:$B$7,FIND(" ",$B$2:$B$7))))=0,"不满足",IF(SUM(((A2-INT(A2))>=--MID($B$2:$B$7,FIND(" ",$B$2:$B$7)+1,5))*((A2-INT(A2))<=--RIGHT($B$2:$B$7,5)))=1,"满足","不满足"))

忙到飞起

=LET(a,(TEXTBEFORE(B2," ")&" "&TEXTSPLIT(TEXTAFTER(B2," "),,"-"))*1,IF(AND(A2>TAKE(a,1),A2<TAKE(a,2)),"是","否"))
不知道是不是想要的效果

宁两好饱

良良 发表于 2024-10-29 20:04
C2=IF(COUNT(VDB(,,(LEFT(B$2:B$7,FIND(" ",B$2:B$7)-1)+MID(B$2:B$7,FIND("-",B$2:B$7)+1,5))%%,(LEFT(B$2 ...

感谢大神，结果一样是2886，谢谢

mjm04

WPS-正则 参与下， 满足条件的订单 2886 个

=IF(SUM(N((A2>=MAP($B$2:$B$7,LAMBDA(a,REGEXP(a,".+(?=-)")*1)))*(A2<=MAP($B$2:$B$7,LAMBDA(a,REGEXP(a,"(\d{2}:\d{2}-)",2,"")*1)))))>=1,"满足","")
下拉