Perhaps you can explain us what you are trying to do there, Jacob, as
MINUTE(10) will return zero. Perhaps you need to look at Excel help for the
MINUTE function to remind yourself what it does.
--
David Biddulph

"Jacob Skaria" wrote in message
...
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. I'd only
need
to return one comparison value to indicate the corresponding time frames
in
the two logs, but still I'm really stumped. Any help would be much
appreciated.