comparing 2 time columns with in array formula

Hi this is the current formula I am trying to get to work

i tried something along these line which obviously did not work is there a way to compare the times of each array withing this formula? It is meant to be the result of a bigger formula which is why I have not placed an if statement in front of it this is the formula causing the trouble:

{=MAX(IF(Sheet9!A3:A50000<DATE(DAY(Sheet1!$E$3),MONTH(Sheet1!$E$3),YEAR(Sheet1!$E$3)),IF(Sheet9!A3:A50000<TIME(HOUR(Sheet1!$E$3),MINUTE(Sheet1!$E$3),SECOND(Sheet1!$E$3)),Sheet9!A3:A50000)))}

the formula is part of this:

{If(or(n,and(x,y,z)),index(y:3:y50000,match(MAX(IF(Sheet9!A3:A50000<DATE(DAY(Sheet1!$E$3),MONTH(Sheet1!$E$3),YEAR(Sheet1!$E$3)),IF(Sheet9!A3:A50000<TIME(HOUR(Sheet1!$E$3),MINUTE(Sheet1!$E$3),SECOND(Sheet1!$E$3)),Sheet9!A3:A50000))),Sheet9!A3:A50000,0))}

any help is greatly appreciated