difference between two dates and before a certain time

[Jackajoo]

I have two columns of dates and I need to know if the 2nd column happened
before 8am of the second column date. So, I have 01/01/09 18:34 in the first
column and in the second column I have 01/02/09 09:17. What formula can I
use to show that the date/time in column 2 is no later than 08:00 the
following day of the first column?

 

[Fred Smith]

Something like:
=if(a2>int(a1)+1+time(8,0,0),"After","Before")

Regards,
Fred

 

[JoeU2004]

What formula can I use to show that the date/time in column 2
is no later than 08:00 the following day of the first column?

One way:

=IF(B1<=INT(A1+1)+"08:00", "no later", "later")

But note that returns "no later" even if B1 is the same day as A1 or even
some day before A1.

If you really meant to say that what a formula that returns "no later" if B1
is between midnight and 8:00 of the following day, then:

=IF(AND(INT(B1)=INT(A1+1), B1<=INT(A1+1)+"08:00", "no later", "earlier or
later")


----- original message -----