LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Time tagging waveform and writing to spreadsheet

Highlighted
I have an application where I to write wave form data to a spreadsheet and analyze this data in excel. I need to have my time tagged data in fractional seconds with 3 digit precision. I have succeeded in writing this data to an excel spreadsheet. However, the seconds roll over to 0 at 60 seconds. The data will have to be modified in excel to make acceptable for our calculations, which takes the current time data point and subtracts the previous time data point. I need a way to keep incrementing the time tag data in seconds with this precision. Is there a way to do this?
0 Kudos
Message 1 of 2
(1,073 Views)
Highlighted
Instead of using the "Export Waveforms to Spreadsheet" VI which converts the time stamp into time/date format, you could write the time data to file as the raw time stamp, which is seconds since Jan1,1903. Excel should have no trouble calculating the relative time from that as long as you treat it as a number rather than a time format. Alternatively, you can generate the relative time in LabVIEW and write that to file.
0 Kudos
Message 2 of 2
(1,073 Views)