Maybe one way:
=IF(AND(B1=A1,B1<=(A1+15)),D1-A1)

HTH,
Paul

"Don" wrote in message
...
Struggling how to create a formula to check if a value falls between two
others where one value is another calculation. My data is:

A B C D
1 07:00:00 07:10:00 07:30:00 08:15:00

I want to say " if B1 falls between A1 and A1+15 minutes, then subtract A1
from D1.
There are other conditions I have written that this will be added to.
Look forward to an elegant solution.
--
Thanks!!
Don