Reply to thread

Message: [QUOTE="Daryl S, post: 3846532"] This formula will work for you. If either I2 or E2 are blank, then you get "No". Then this tests for hours differences and minutes differences. The hour difference is allowed to be one if the minutes difference is zero. I have used ABS (absolute value) in the date differences because it looks like either date/time could be earlier. =IF(I2="","No",IF(E2="","No",IF(HOUR(ABS(E2-I2))>0,IF(HOUR(ABS(E2-I2))>1,"No",IF(MINUTE(ABS(E2-I2))=0,"Yes","No")),IF(MINUTE(ABS(E2-I2))<=60,"Yes","No")))) Try it out... [/QUOTE]