One More Question About Time Stamps and Excel

[Jim_Flip]

Good Morning Everyone,

I know this has been covered in excruciating detail before, but I have tried with no luck for some time now to try to understand how to get a  time stamp written to a text or spreadsheet file from LV and import it into Excel and have it recognized as a valid time format. I don't know if it is a problem I am having in Excel or LV.

I have tried using the Nice Time.vi written by one of you nice people, but I cannot get the time to be recognized by Excel.

Here is my mod of the nice time.vi.

Any suggestions are very welcome.

James

[tuned99]

You can replace all that time calculation by taking that timestamp and formatting it directly into a string of your choosing.  See the help in the "Format Date/Time String" for more details.  Your code can be simplified with two vi's though you can retain it if you need that Current Time array for some other purpose.

In fact, if you can get away with 12-hour time format, you can simply use the "Get Date/Time String" with the seconds enabled.

Message Edited by tuned99 on 08-03-2005 03:23 PM

[Jim_Flip]

Thanks for the reply! I now have Excel recognizing the format and am working on the LV part of Get/Time/Date Stamp.

James