If Functions for Lates
 

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

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

One way:

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

In article ,
"LostNFound" wrote:

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.

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

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 :)

"LostNFound" wrote in message
...
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

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

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")

In article .com,
"IlanR" wrote:

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

Thanks, now it make sense
Nice approach
Ilan

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 off


--
pumakel