difference between two dates and before a certain time
Something like:
=if(a2int(a1)+1+time(8,0,0),"After","Before")
Regards,
Fred
"Jackajoo" wrote in message
...
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?
|