Sorry JE. You're correct. I skimmed through this one fast and did not pay
attention to the fact that these were times.
Thanks for the correction.

Paul

"JE McGimpsey" wrote in message
...
Did you try it?

This will always return TRUE if B1 is entered as a time, since times are
less than 1, and A1+15 is 1

In article ,
"PCLIVE" wrote:

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