Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need formulae
Hi all I have the following criteria:
planned = 4; 1 hour above planned = 3; 2 hours above planned = 2; 3 hours above planned = 1 I need a formulae to satisfy the above requirements (i have a helper cell "a51" E1=PLANNED DATE TIME (dd-mm-yy HH:mm) F1=ACTUAL DATE TIME F1-E1=HELPER CELL(A51) REMEMBER IF A51=O THEN THAT IS 100% PLANNED THANKX GEES |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using two formulae | Excel Worksheet Functions | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
age formulae | Excel Discussion (Misc queries) | |||
Help with a formulae | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |