View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jackajoo Jackajoo is offline
external usenet poster
 
Posts: 7
Default Time - By 8am the next morning

I have two columns with date and times. I need a formula to show that the
date in the second column was no later than 8am the day after the date/time
in the first column. For example:

A1
04/05/09 14:35 PM

B1
04/06/09 11:01 AM

So using my explanation above, this would be "not compliant" with the
scenario and I would like an "N" returned.

A compliant example would be:

A1
04/06/09 14:35 PM

B1
04/07/09 07:30 AM

Is there a formula for this? Thanks!!!