Time/priority problem
$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
|