If Functions for Lates

[LostNFound]

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

 

[JulieD]

hi

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

Cheers
JulieD

 

[JE McGimpsey]

One way:

=IF(C1>(2-(A1=1))*TIME(0,15,0),"yes","no")

 

[LostNFound]

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

 

[JulieD]

Hi

you're welcome .. thanks for the feedback, but JE's formula is much "neater"
than mine so you might like to give that one a go too / instead

Cheers
JulieD
PS my email address shouldn't be that hard to figure out

 

[IlanR]

Enlighten me please, how your formula uses the data in Col B
Thanks
Ilan

 

[JE McGimpsey]

I apparently misinterpreted "above column B" to mean the location where
the formula was to be entered.

If you have two times, say, a start time in B1 and an end time in C1,
then use

=IF((C1-B1)>(2-(A1=1))*TIME(0,15,0),"yes","no")

 

[IlanR]

Thanks, now it make sense
Nice approach
Ilan

 

[pumakel]

i'm doing gcse it so i'm not very confident.

if a1 =1 true

thats all i can do sorry
some one else can finish it of