09-16-2021 02:22 PM
Hello all, I am currently trying to read 2 to 3 channels from a DAQ USB-6255 and record it to a spreadsheet with a timestamp. I can sucessfully record two channels but when I get the time in its column it logs the UTC in absolute seconds in the first column but will log zeros afterward. Any ideas on how to get around this? Thanks for the help.
09-16-2021 02:52 PM
Hi liconj,
I made a little change on your VI.
Hope it works properly now.
Regards,
09-16-2021 03:29 PM
Looks like that worked for logging the time, but it is still being logged as absolute time vs. relative time though.
09-16-2021 04:36 PM
maybe this would work for you
09-16-2021 04:38 PM
Several comments:
Bob Schor
09-20-2021 11:32 AM
Thanks, I was able to convert the timestamp to days since Jan 1 1904. At that point I can just change the format in excel. Thanks again!
09-20-2021 02:07 PM
I'm sure you realize that simply multiplying the Dbl you get from a LabVIEW TimeStamp and saving that in an Excel cell formatted as "Date/Time" does not get you the correct year, right? Of course, if you are only expressing "Relative Time", then "Date" becomes largely irrelevant ...
Bob Schor