append time stamp as a column in an excel file

[trout00]

Hi

i want to add timestamp to the last column  of my excel file

my data is this 

columnA   columnB  column C  columnD

temp10     temp11    temp12     timestamp       these are header name

74.212     73.122     73.222      11AM:23:59.012

73.444     73.223     74.322      11AM:24:02.083

73.445     73.478     75.555       11AM.24:03.833

  and continue

I can use write spreadsheet to have the three numeric tempdata but the last column formatted as time stamp and string 

how do I add time stamp to my data and call the spreadsheet write VI to append to the excel file ?

help

[johnsold]

You have at least two possibilities:  One is to do the formatting yourself with string functions and write the data as a text file or an array of strings.

Another is to convert the timestamp to a Double and save it as numeric data.  This is only useful if your are going to read the data back into LV and analyze it there, because Excel's numeric representation of date and time is different from that used by LV.

Lynn 

[Adam_H · Accepted solution]

Hi trout00,

I agree with johnsold.  I think your best bet will be to use a string and do a little formating your self.  It should not be to difficult.