Still on the inclusion of the time/date field into the spreadsheet file, with 2 real values?

[matrix]

I have tried to convert the 2 real values to decimal strings, and then taken these 2 values, as well as the date/time strings, put it into an array, converted the array to decimal number, and plugged it into the 1D input of the spreadsheet vi. However, for the date and time, i get the first part only, in a decimal.i.e,for 12:30pm-->12.0000 and for 23/04/2001-->23.0000.
How can i get the right values, show me an example if u can.
Thanks.

[Gorka Larrea]

1- Open write to spreadsheet file vi.
2- Save a copy as "Write string array to spreadsheet.vi" or something.
3- Open this copy.
4- Replace the numerical controls in the 1D and 2D arrays with string controls.
5- Save this vi
6- Now you can wire a string array to this vi and have a spreadsheet from there.
Remember to modify the COPY, and be careful with the format string.