Date and Time in an array of numbers - is that possible?

[johanneshoer]

Hello,

I have an array with float precise measurement data and I save it in a spread sheet, so that I can easily open it with Excel.

Now I want to save the date end the time as well.

To achieve that, I changed the array from doubles to string and converted all numbers and the date and time to strings, but that is not very economic.

Can I save the date and time in a numeric format, which excel can interpret as date and time?  

I am thinking of the following:

These numbers:

39303

0,66134502

converted into date and time format in excel become:

09.08.2007

15:52:20

How do I convert date and time to numbers in LabVIEW, so that excel can convert it to date and time again?

Johannes

LabVIEW 7.1 (!)

[MikeS81 · Accepted solution]

Hi Johannes,

this link should help.

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Mike

[Pattos]

Hi Johannes,

I am not sure if there is timestamp to seconds function in 7.1, but if there is one, use it.

alternatively you would have to do things the hard way, transform the timestamp to a string and that string to a number or something like that.

you would have to transform the numbers to the right format anyway.

Regards,