Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- sonic-the-mouse |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
priority setting | Excel Discussion (Misc queries) | |||
Priority (with macro??) | Excel Worksheet Functions | |||
Priority Charge | Excel Discussion (Misc queries) | |||
New Priority Column | Excel Discussion (Misc queries) | |||
how do i set up tab field priority? | Setting up and Configuration of Excel |