How to include seconds and millisecond in the CSV file time stamp generated by the SpreadSheet Object?

[Rudy Lopez]

I'm Using Lookout 6.02, in a XP Pro Windows Machine, Service Pack 3.

I have an application that collects data at the rate of 20 samples per second. It works just fine, the CSV File contains all the samples without missing a single one.

The problem is that the time stamp in the data file only shows hours and minutes. With 20 sample per second, there are 1200 samples per minute. It is hard to figure out in which second or sample number, occurred some events collected. These files are open with Excel and analyzed with Excel. There is no easy way to implement a search or a guidance for knowing the sample number or the exact time in Excel.  My problem is to add the seconds and if possible the milliseconds to the time stamp done by the spreadsheet object.

Any suggestion?

Other ways to do the same that includes the time stamp all the way down to milliseconds?

[Mike@DTSI]

Create another column with the Now() function, then set the calumn format to hh:mm:ss.s

expression would be now(trigger) for the date and time or now(trigger)-today(trigger) for just time

The trigger will cause the expression to stay updated, perhaps using the same trigger for logging the spreadsheet.

Good luck

Mike

Message Edited by Mike@DTSI on 01-16-2009 04:12 PM