AndrewB wrote...
I have a list of date & times of deliveries. I also have a
list of date &
times of price changes. I want to identify if, for each delivery
time, it
falls within 7 hours either side of any one of the price changes
and, if so,
which side.

Given a date/time of delivery, D, and the date time of a price change,
C, the formula you seek is

=IF(ABS(D-C)<=7/24,IF(D<C,"Before","On or After"),"Outside 7
Hours")

If there were m delivery dates/times in a horizontal range D and n
price change dates/times in a vertical range C, the formula above
would be an array formula that would return an m-column by n-row
array result.
---------
www.coffeecozy.com

Use your Bodum and give up cold coffee for good!