Time/priority problem

[sonic-the-mouse]

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

 

[Mike H]

Hi,

Where
K2= Y
L2 = 02:00

try this

=IF(AND(D2=K2,E2>L2),"Something","Something Else")

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

Mike

 

[Jacob Skaria]

$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