DATE and TIME

[*E*]

Im acquiring Temperture readings and writing them to the A column of a Excel Sheet. How can i Acquire the  time and place it in the same excel sheet in the same column or the Column B?

[Dennis_Knutson]

What exactly are you having problems with? You have the functions on the Timing palette to get Date/Time as a string or as a numeric (seconds since 1/1/1904). There have been numerous posts on converting the numeric to Excel seconds.

[Jonas_Stein]

i use "Tickcount (ms)" and subtract the starttime if i need the timestamp since the program was started

[*E*]

Thanks for the reply. I am able to write my temperature date to Excel and im also able to write the time stamp but i can not do them both together. I would like for the Temp data to be in Column A and Time Stamp on the Right of it in Column B.

[Jonas_Stein]

you can collect the data in a formatted string and write it to a .csv file

[Dennis_Knutson]

Pretty hard to tell what you are doing wrong when you don't post the code.

[Tim_O1]

Hi *E*,

Below is an example to write to a spreadsheet into two columns. If you are just getting one string for both your Temp and Time then parse them into two string and add one to Column A and the other to Column B otherwise just build an array and put your Temp and Time in separately.

https://decibel.ni.com/content/docs/DOC-2101

Tim O

[*E*]

Thanks Tim O