The original routine had the sign wrong on the Time Zone.
Here is the updated UTC Time Zone VI and the ExcelDateTime.vi
This converts dates from Excel numeric value (Re Format a column of dates in a spreadsheet to Numeric and these numbers are the excel dates I'm starting with). The conversion is to LabVIEW Time Stamp. There is a reverse function included in the same VI.
It is possible to determine your time zone from the G function Seconds to Date/Time.
1)feed in Zero this will give 1904-01-00 0:00:00 at Greenwich, but if you are in Montreal it gives 1903-12-31 20:00:00. (In the summer time) That's -4 hours offset.
2)Leave the Seconds input unconnected (Now) and examine the output Time Structure for DST. Add another hour for the Daylight Savings Time and you arrive at -5 which is out time zone.
3)This routine should work all over the world (Maybe even in Newfoundland which is 30 minutes ahead of Montreal.)
Download File:post-230-1122943401.zip