Hi,
=IF(A51<0,4,IF(AND(G1-A51=0,G1-A51<=2),3,IF(AND(G1-A512,G1-A51<=3),2,1)))

"Graham" wrote:

Hi Eduardo
a small correction :IF A51<0 then =4, IF=0 but <2 then =3,IF 2 but <=3
then=2,IF 3 then =1
This is the situation I have to satisfy, please help

"Eduardo" wrote:

Hi,
I assume the first condition is =Planned and that your helper is in G1 in H1
enter
=IF(A51=0,"100%
Complete",IF(G1=A51,4,IF(G1-A51=1,3,IF(G1-A51=2,2,IF(G1-A51=3,1)))))

"Graham" wrote:

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