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