View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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?