Log data from NIELVIS oscilloscope program

[DAK_Trap]

When you save the data the time data is mm/dd/yyyy hour.min.sec and there are plenty of decimals to recognize it if you look at the raw numbers but excel does not know what to do with it. I know a few ways around it. Use the dt and create my own time array, write another program to put the time stamp into seconds. Does anyone know of a quick way to get excel to interpret the output so that the data can be plotted in excel? I know labview can deal with the data as is. I was just wondering why is the time data saved as a time stamp instead of just in seconds.

Thank you,
Desmond
dakaplan@unc.edu

[craigherdman]

Desmond,

There is a VI in LabVIEW called �Date/Time To Seconds� that will take the time stamp data and convert it to seconds. This VI can be located by right-clicking on the block diagram and selecting Functions->All Functions->Time & Dialog->Date/Time To Seconds. I have attached a program that illustrates its use. LabVIEW provides other VIs to handle time stamp conversions to formats that are used programmatically in other instances.

You can also use the �Get Date/Time in Seconds� VI located in Functions->All Functions->Time & Dialog. Here is a Knowledge Base that discusses how to use this VI with spreadsheets:

�Date/Time Data�

For further
assistance feel free to access the online support pages at www.ni.com/support. From here you can search through our online Knowledge Base to come up with more examples and helpful discussions. If you have any other problems please post back. Thanks!

Craig H.
National Instruments

[DAK_Trap]

Thank you, I appreciate the example and it is good to have it posted so users of ELVIS know there is a solution with in labview. I was actually familiar with that function. I guess my question was more of a request for the future. I think it would be more useful for the oscilloscope program that is built in with NIELVIS 1.0 to output the time data in seconds rather a time date stamp. I think seconds is more universal for waveform data. Now the user has to go through an extra step to deal with the log data from ELVIS. I am just thinking about the students. I personally have no problem with the extra step but I am developing an academic lab for teaching purposes and the less steps the students have to go through, at first, the better. Just a thought.

Th
ank you for your support it is appreciated.

Desmond