How to put miliseconds in Export Waveform to Spreadsheet

[Jrr]

HI,

I have to read my waveforms values: Y and X, x is the timestamp. But, for me, it´s better to save my results using the Export waveform to Spreadsheet. So, after some time wasted I find a way.

1. Double click in Export waveform to Spreadsheet.
2. Find in the Block diagram the VI "Waveform time to date time string".
3. Open it.
4. In the subvi called "Format Date/Time String", change the time format to something like "%M:%S%5u"
5. Save all
6. Test it.

Before I do this my results are like this:
12/2/2008  09:18:26,    -0,000408
12/2/2008  09:18:26,    0,062740
12/2/2008  09:18:26,    0,124921

After that:

12/2/2008  06:49,97358     0,000237
12/2/2008  06:49,97368     0,062418
12/2/2008  06:49,97378     0,125244

Increased the precision (more than miliseconds).

Question:

Is there an easier way?


thanks

🙂

[chrisger · Accepted solution]

hi there

at least in LV 8.5 they changed the format to %H:%M:%S%6u.

Be aware: DO NOT replace ANY of the files in the vi.lib directory. The results may be unpredictible..

[Jrr]

Uhmmm
thanks man , I have labview 8.2

And i did a "save as" when i changed this things..
Never know..


hugs

[MaxXx]

Hello,

Does anyone know how to remove the preceeding date?

Currently, the timestamp I get is something like:

04/16/2009  00.0000024

04/16/2009  00.0000028

I just want it to be in milliseconds like:

00.0000024

00.0000028 

I tried removing everything and leaving only "%S%7u" in the format but it still return the date.

Thank you,

Max

[Dennis_Knutson]

Removing the hours and minutes will obviously not remove the date. Do you not see the Get Date/Time String function that is returning the date? Turn on Context Help. In fact, it should always be on.