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?
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.