Time in cell B2 and its accurasy

[alrodopial]

With refresh rate of 0.2 sec If I use two consecutive times from cell B2 can their difference give me millisecond accuracy?
Is the time with milliseconds accuracy exists in the B2 time format or do I have to use the VBA "Timer"?

[GaryRussell]

The time format for cells cannot store milliseconds.

Your best bet is to check elapsed times between worksheet_change events when Target.Columns.Count=16 which is when cell B2 is written.

The Windows API timer function described here is probably the most accurate option.

[alrodopial]

Thanks for the answer and the link.
Some thoughts:

Time in cell B2 is actually a number with the delimiter part represent the hours of the day.
So if it is 1 (one) it is equal to 24 hours,equal to 86400 sec so
1 sec = 0.000011574 (1/86400)
If I get two time logs from cell B2 and their diff is 0.000011574 I assume this is 1 sec diff?
If I divide their diff with the 0.000011574 I will get this diff into secs and with accuracy of more than millisecs? Am I doing something wrong?

[GaryRussell]

I would round it to milliseconds. ie. =((B-A)/0.000011574)*1000 where B=current time and A=previous time.

BA itself only records the time up to millisecond accuracy. Why do you want more than millisecond accuracy? Please don't ask me to make BA accurate to more than 1 millisecond because I cannot provide that.

[GaryRussell]

1/86400 is actually 0.0000115740740740741

It would be more accurate to use the following formula.
=((B-A)/(1/86400))*1000

[osknows]

The time format for cells cannot store milliseconds.

It's possible to use a custom format in excel to show millisecond accuracy if the cells contains that amount of precision.

Eg Format cell as Custom

'dd/mm/yyyy hh:mm.000'

or just

'hh:mm.000'

[osknows]

Ignore what I said. I see your trying to get ms only!

[GaryRussell]

Your information is useful though. I have to admit I was wrong

[osknows]

I made a mistake also, forgot the seconds! Format should be

'dd/mm/yyyy hh:mm:ss.000'

or just

'hh:mm:ss.000'

or even

'ss.000'

[alrodopial]

Thanks guys , two digit precision is enough.
Never wanted more but since English isn't my native language it looks that I wasn't clear enough.