Time/priority problem

I am trying to set up a spreadsheet to report on how we are meeting our priority orders in line with time constraints

col A - Date
Col B - Time order in (format hh:mm)
Col C - Time order out (format as col b)
Col D - Is it a priority order Y/N
Col E - Time taken from receipt to complete (sum col c - col b) (format [mm])

My problem is Col F where i am trying to return a figure/text for if col d is a priority and col E is greater than 120 minutes

Tried =IF(E2=$K$2,D2=$L$2,1) where k2 = Y and L2 = 120 but it returns FALSE for every cell that is a priority no matter how long it has taken.

Any help gratefully received,

Frustrated

Hi,

Where
K2= Y
L2 = 02:00

try this

=IF(AND(D2=K2,E2L2),"Something","Something Else")

Your cersion is going wrong where you compare 120minutes (E2) to the number
120 (L2)

Mike

"sonic-the-mouse" wrote:


I am trying to set up a spreadsheet to report on how we are meeting our
priority orders in line with time constraints

col A - Date
Col B - Time order in (format hh:mm)
Col C - Time order out (format as col b)
Col D - Is it a priority order Y/N
Col E - Time taken from receipt to complete (sum col c - col b) (format
[mm])

My problem is Col F where i am trying to return a figure/text for if
col d is a priority and col E is greater than 120 minutes

Tried =IF(E2=$K$2,D2=$L$2,1) where k2 = Y and L2 = 120 but it returns
FALSE for every cell that is a priority no matter how long it has
taken.

Any help gratefully received,

Frustrated




--
sonic-the-mouse

$L$2 may not be in minute format. Convert that to minutes and compare...

=IF(D2=$K$2,E2=TIME(0,$L$2,0),1)

If this post helps click Yes
---------------
Jacob Skaria


"sonic-the-mouse" wrote:


I am trying to set up a spreadsheet to report on how we are meeting our
priority orders in line with time constraints

col A - Date
Col B - Time order in (format hh:mm)
Col C - Time order out (format as col b)
Col D - Is it a priority order Y/N
Col E - Time taken from receipt to complete (sum col c - col b) (format
[mm])

My problem is Col F where i am trying to return a figure/text for if
col d is a priority and col E is greater than 120 minutes

Tried =IF(E2=$K$2,D2=$L$2,1) where k2 = Y and L2 = 120 but it returns
FALSE for every cell that is a priority no matter how long it has
taken.

Any help gratefully received,

Frustrated




--
sonic-the-mouse