=IF(AND(OR(F5="COS",F5="ACE"),B5--"11:00:00"),IF(K5<B5,"Late","Early")&TEXT(ABS( K5-B5),"hh:mm:ss"),IF(OR(F5="ACE",AND(F5="COS",B5<=--"11:00:00")),IF(J5<B5,"Late","Early")&TEXT(ABS (J5-B5),"hh:mm:ss"),""))


--
__________________________________
HTH

Bob

"puiuluipui" wrote in message
...
Hi, i have this code:


=IF(AND(F5="COS",B5--"11:00:00"),IF(K5<B5,"Late","Early")&TEXT(ABS( K5-B5),"hh:mm:ss"),IF(OR(F5="ACE",AND(F5="COS",B5<=--"11:00:00")),IF(J5<B5,"Late","Early")&TEXT(ABS (J5-B5),"hh:mm:ss"),""))

Can i make the code something like :

=IF(AND(F5="COS",B5--"11:00:00"),IF(K5<B5,"Late","Early")&TEXT(ABS( K5-B5),"hh:mm:ss"),IF(OR(F5="ACE",AND(F5="COS",B5<=--"11:00:00")),IF(J5<B5,"Late","Early")&TEXT(ABS (J5-B5),"hh:mm:ss"),""))
and
IF(AND(F5="ACE",B5--"11:00:00"),IF(K5<B5,"Late","Early")&TEXT(ABS( K5-B5),"hh:mm:ss"),IF(OR(F5="COS",AND(F5="ACE",B5<=--"11:00:00")),IF(J5<B5,"Late","Early")&TEXT(ABS (J5-B5),"hh:mm:ss"),""))

Thanks.