Count Unique Text String

the formula is not calculating last 2 values i.e 0:29 in row no. 538 & 539

Well, it works for me in this sample file - I see that your original formula referred to cells AR5 and AR6, whereas it is I5 and I6 in this file, so presumably your real file is somewhat different to this one. Perhaps that might explain the difference.

Pete