converting 0.000 number into milliseconds in excel

Question

I have acquired some data at a rate of 200Hz and instead of time stamps it gives me the time in 0.000 format:

0.0
0.005
0.010
0.015
and so on...

I have tried to convert this to time format (using =TIME(,,A1)) but it ignores the values after the dot (the milliseconds) and only calculates the time in hh:mm:ss. This gives me a bunch of numbers with the exact same value and I can't visualize my signal properly on a chart or do any further analysis.

Does anyone know how can this be solved?

Thank you very much in advance!!!

Answer 1

To extract the seconds you can do:

=FLOOR(A1,1)

To extract the milliseconds you can do:

=MOD(A1,1)*1000

Answer 2

If A1 contains 0.001 and this represents 1 millisecond, then in another cell enter:

=A1/86400 and format this cell as Custom hh:mm:ss.000