Suppose you have the times stored in Col A and Col B

=IF(B:B-A:AMINUTE(10),"close",IF(B:B-A:A<MINUTE(10),"close",""))

--
If this post helps click Yes
---------------
Jacob Skaria


"Hugh" wrote:

I have two event logs which I am trying to compare. How can I establish if
an event in one log occurred around the same point in time of any event in
the other log, bearing in mind that the times of the events in each log may
not be exactly coincident, but might be 5 or 10 minutes apart. Id only need
to return one comparison value to indicate the corresponding time frames in
the two logs, but still Im really stumped. Any help would be much
appreciated.