|
楼主 |
发表于 2022-6-3 11:58
|
显示全部楼层
=IF(OR((TEXT(MOD(A2,1),"hh:mm:ss")<="16:00:00")*(COUNTA(IF(INT(A2)+1<=INT(B2)-1,(NOT(IFERROR(MATCH(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)),O:O,),0))*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=6)*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=7)),0))>1)*(SUM(IF(INT(A2)+1<=INT(B2)-1,(NOT(IFERROR(MATCH(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)),O:O,),0))*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=6)*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=7)),0))=0)*(TEXT(MOD(B2,1),"hh:mm:ss")<="12:00:00"),(TEXT(MOD(A2,1),"hh:mm:ss")>="16:00:00")*(COUNTA(IF(INT(A2)+1<=INT(B2)-1,(NOT(IFERROR(MATCH(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)),O:O,),0))*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=6)*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=7)),0))>1)*(SUM(IF(INT(A2)+1<=INT(B2)-1,(NOT(IFERROR(MATCH(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)),O:O,),0))*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=6)*NOT(WEEKDAY(ROW(INDIRECT(INT(A2)+1&":"&INT(B2)-1)))=7)),0))=1)*(TEXT(MOD(B2,1),"hh:mm:ss")<="12:00:00")),"未超时","超时")
非常感谢,这火车太长了,看不懂
|
|