match with 2 criteria within a 30 seconds time range.

[biskwit]

Hi Ladies and Gentleman!


I have a problem. Please help with a formula where it check for a time range, lets say 30 seconds.

Right now my formula is:

=INDEX($AK$2:$AK$1650, MATCH(1,(AI2=$AF$2:$AF$1650)*(AJ2=$AG$2:$AG$1650),0))

What it does is it look for exact matches for two criteria, the phone number and the Call Time.
Now my problem is, i want it to match within a 30 seconds or 1 min time range.


​

	AF	AG	AH	AI	AJ	AK	AL
1	Caller	Answer Time	ID	Caller	Call Time	ID	ok=not abandoned
2	3103875551	4:14:28	ok	3103875551	4:13:27	ok	#N/A
3	3103875551	4:15:32	ok	3103875551	4:14:28	ok	ok
4	3103875551	4:16:59	ok	3103875551	4:15:53	ok	#N/A
5			ok			ok
6			ok			ok

<tbody>
</tbody>

**on AL3 it returns an "ok" because AI3 and AJ3 found a match on AF2 and AG2.
**on AL4, it returns #N/A because AJ = 4:15:52 is not the exact match of AG = 4:15:32. So i want
the formula to match the time within a range of 30seconds or 1 min. So that AL4 would return an "ok"
as well.

Thank you, i hope you understand my issue.