02-11-2010 12:35 PM
Solved! Go to Solution.
02-11-2010 01:29 PM
02-11-2010 02:18 PM
Hi Putnam,
I have made changes to the VI following your suggestions and it works to my purpose. I have attached the updated VI for you to see. I was making changes to my need but did not end up using "array to spreadsheet". Please advise me if you think there is any better way or improvements I can make to this VI. Thanks for your help.
02-11-2010 03:33 PM
here's a "better" method Time is stored in Excel as a number but displayed as a date-time. If you ever want to graph vs time you can't use the time text since Excel doesn't really understand that the string "1/1/1900 12:00:00.0" = 1.
Oh- Now that I moved my reuse library to 2009f3- I took the time to add a work-around for the infamous Excel 1900 leap-year bug
Enjoy
02-12-2010 08:17 AM
11-22-2010 03:07 AM
Hi Jeff,
just found your Time-to-Excel VI and have to report some minor problem:
When using your VI on a German WinXP your "Zone" output is misformed due to German umlauts in the timezone string.
"%Z%z" results in "Westeuropäische Normalzeit01:00:00" which is converted to "WäN01:00:00" by your filtering loop. But who needs this string anyway?
The remaining VI looks quite nice!