Hi John,
Excel stores dates (usually) as number of days since 01.01.1900 - hence 39485 is 07.02.2008.
You can do two things:
1) switch excel to use the 01.01.1904 as start date (like LabView does)
2) subtract the offset of 4 years (number of days=1462) from the Excel date number (39485-1462)
Then you have to multiply the resulting number by 86400 (seconds per day), this can be wired to the LabView time functions...
Message Edited by GerdW on
02-18-2008 12:59 PM
Best regards,
GerdW
using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019