This VI allows you to convert the timing from LabVIEW to excel Time.
The time format in LabVIEW is different from the time format in Excel. If you simply convert the timestamp cluster to a double and paste that data into an Excel it wont make sense. This is because the Excel time format is based on the number of days since 1 Jan 1900. The LabVIEW time is based on the number of seconds that have passed since 1 Jan 1904. This vi converts the LabVIEW time to Excel time.
You can find another implementation with daylight saving here.
LabVIEW 2012 (or compatible)
Steps to Implement or Execute Code
1. Download and open the attached VI LabVIEW Time to Excel Time_LV2012_NI Verified
2. Run the VI
Additional Notes or References
**This document has been updated to meet the current required format for the NI Code Exchange. **
Justin Parker National Instruments Product Support Engineer