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 |
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 |