Awesome!! I Love It
Thank You
Very Quick
I need your E-mail addy (Ha Ha)
Thank You

"JulieD" wrote:

hi

you could use a formula like
=IF(AND(A1=1,C1-B115/1440),"yes",IF(C1-B115/1440,"yes","no"))

Cheers
JulieD


"LostNFound" wrote in message
...
I want the formula to look in column A and if there is a 1 and column C is
greater than 15 minutes above column B I want it to return a "yes".. But
if
Column A is not a 1 then I want to use 30 minutes as the standard. and
perform the same function. If the time in C is less than the 30 or 15
minutes
then I want it to return a "No"

I am trying to track the delivery times wether they were Late or Not and
the
first stop we have a fifteen minute window while all others are 30 minutes
and early is not a problem.

Thanks To all who can contribute