I need some help

[sidinoz]

A friend at work coded this sheet for me to append each duplicate date time in column B by .001 but the formula repeats at .003 and .010 and at other .0xx as the duplicates increase. The code is the same for each cell in column C but I can figure out why it repeats only at certain numbers. I don't have Excel at home and I can't use message boards at work so Im hopin an image and the code is all you need.
Column A is the original time column B has the code
=IF((IFERROR(MATCH(A3,$A$2:A2,1),0))>=0,A3 + C3*0.00000001, B3)
Column C has the code
=IF(A3=A2,C2+1,1)

 

[offthelip]

I suspect you are falling into the excel trap of precision, you are adding a very small number to a number which is about 44 thousand. What I suggest you do is try changing the constant you are multiplying by to a constant a lot larger like this:

=IF((IFERROR(MATCH(A3,$A$2:A2,1),0))>=0,A3 + C3*0.000001, B3)

( I have deleted two zeroes from your constant. )
To explain my reasoning for this have look at this article:
Floating-point arithmetic may give inaccurate result in Excel - Office

 

[johnnyL]

Column A is the original time column B has the code
=IF((IFERROR(MATCH(A3,$A$2:A2,1),0))>=0,A3 + C3*0.00000001, B3)

You need to use a more accurate number for the millisecond.
0.000000011574074

 

[sidinoz]

You need to use a more accurate number for the millisecond.
0.000000011574074

Thankyou.

 

[sidinoz]

You need to use a more accurate number for the millisecond.
0.000000011574074

Thank you.

 

[johnnyL]

Glad we could help.

 

[sidinoz]

Both solutions worked.