LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Converting LV Time Stamp from Excel

Solved!
Go to solution

Thanks for the background and information - it is much appreciated.

0 Kudos
Message 21 of 22
(444 Views)

Additional info 

 

Excel spreadsheets do have a writable property for Time Epoch.  So, Excel can use the same Epoch LabVIEW uses.  HOWEVER, Excel copied a bug from Lotus and forgot that Pope Gregory was inspired to decree that only every 4th century ended with a leap year.  2000 was a leap year 1900 was not even though Excel says 29 Feb 1900 existed.

 

So, the only LabVIEW examples that I am aware of that account for that bad behavior are; Time to XL and XL to Time.


"Should be" isn't "Is" -Jay
0 Kudos
Message 22 of 22
(436 Views)