Hi and thanks for the reply.
The .CSV is created in an OptoScript block. We build the string and tack on .CSV to the end.
We need the time stamp column to be in this format: 09:45:23.000 where 09 = Hours, 45 = Minutes, 23 = seconds, .000 = milliseconds. We are not concerned with accuracy to the Msec, but the WonderWare server expects to see .000 for Msec. I know the script we’ve written is formatting it correctly because it shows up in Notepad the right way.
If I paste this format into a cell in Excel, it takes off the hh and all I see is 45:23.0. This seems to be a known problem as I’ve read many forums. They all say to use the “Custom” format within excell and it of course, it works.