Set data with minute minute seconds and milliseconds

[RicardoRebeloo1]

Hello my name is Ricardo, and I'm doing measurements it with an inertial sensor. I'm working with a frequency of 10 Hz so every second I have 10 measurements, when I export data to excel the time just appears in this format: HH: mm: ss but it doesn't appear to me in milliseconds. I can't find the format with milliseconds. If anyone can help me I would appreciate it very much.

[RTSLVU]

You are doing it wrong...

An Excel time is NOT text you need to save it as a floating point number, then you can use Format Columns function in Excel to show the time with milliseconds.

[RicardoRebeloo1]

but what should I record as a "floating point number" you can draw on this impression that I leave here please:

[RicardoRebeloo1]

i cant put in the floating point  ....

[RavensFan · Accepted solution]

Since you are saving it as text file,  you need to use the a better number to string conversion.  Don't use that particular Date Time function.  Use Format into String with a format of %<%m/%d/%y %H:%M:%S%3u>T

If you expand it further and add %.2f, you can put all those values together in one shot.

[RicardoRebeloo1]

this: