format time for excel

[Ariel]

I want to take the time data i have, and make it 'nice' for excel, so when i send this array of numbers to excel, excel knows the time and date and shows that. does this have to be done in excel afterwards (by formatting the col)? or do i have to make the time into a string and write the time string to excel as an array of strings? can i even do that? I'm useing the write to spreadsheet vi example.

[Zvezdana S.]

It would be best to format the time in LabVIEW before you send it to Excel. The best format for time numeric is to select its representation to be I32, and under Format&Precision select Decimal format, Relative Time (seconds).
The attached example shows how to measure the current time, and display it in an array with relative time format. It is created with LabVIEW 6.1

Zvezdana S.
National Instruments

[Ariel]

Thanks for the example code, however when i use your suggestions in my own code, i get numbers like 856745:47:33.23 the 47:33.23 is good, that the correct minutes and seconds, but what is the number up front? how can i get that into something nice? Thanks again...