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