=LET(x0_,DROP(A1#,-1),x1_,DROP(A1#,1),IFERROR( (INDEX(x0_,,2)=INDEX(x1_,,2))*(DROP(x1_,,3)="IN")*(DROP(x0_,,3)="OUT")*(INDEX(x1_,,3)-INDEX(x0_,,3)),))