LabVIEW
Set data with minute minute seconds and milliseconds
Solved!
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.
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.
but what should I record as a "floating point number" you can draw on this impression that I leave here please:
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.
