I have results files from an instrument logging at 10Hz with a numeric timstamp in column 0 (from labview program which logs the instrument and writes to spreadsheet at %.3f). I have a timing problem exemplified in the attached vi screenshot (input and example results files from it too large to attach)
If I convert the numeric timestamp in the input (.ec) files to a string or a date time record cluster in labview the time differs (order of seconds) from that when the numeric timestamp is converted to date time display in excel (see highlighted in the excel results file). The numeric timestamp in the output appended array matches that from the input files when directly opened in excel so I do not think its a problem with precision at the read/write from spreadsheet. I assume that this numeric timestamp is also therefore the true time. The problem seems to be with the conversion to a date time string or date time rec cluster in LabView, any ideas why this is (I guess an offset could be added to the datetime numeric before conversion to string or cluster to give the correct values but I would like to know why this is happening. Thanks,
Emily
