I allways do click on yes.
Can you help me with the last question?
Thanks allot.

"Max" a scris:

It's working ...
Welcome, but pl mark that response by clicking the YES button there

but i have one more question ..

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

If above helps, pl mark this response as well
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
--
"puiuluipui" wrote:
It's working, but i have one more question. In B5 with "COS" , the code can
sometimes find 08:00:00 and 12:30:00, so the reference can be either M5 or L5
Can the code, only in "cos", display the result by the time? The same thing
with "late" and "early".

If it's less than 11:00:00 the reference to be "L5"
If it's bigger than 11:00:00 the reference to be "M5"

Thanks in advance.