P
puiuluipui
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"),""))
The problem is that this code it's working only for "COS" situation. For
"ACE" situation i have to change the referance "K5" and "L5" manually. But
it's time consuming. I need one code for both situations.
i have two groups
("COS" and "COS 1") (referance "K5" and "J5") with "time" (<11:00:00) and
(>11:00:00)
and
("ACE", "VAN" and "ACH") (referance "L5") and no "time"
Can this be done?
Thanks in advance!
=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"),""))
The problem is that this code it's working only for "COS" situation. For
"ACE" situation i have to change the referance "K5" and "L5" manually. But
it's time consuming. I need one code for both situations.
i have two groups
("COS" and "COS 1") (referance "K5" and "J5") with "time" (<11:00:00) and
(>11:00:00)
and
("ACE", "VAN" and "ACH") (referance "L5") and no "time"
Can this be done?
Thanks in advance!