silver

Dear Friends,

My code is so far working, but I have the following task to accomplish.

I am converting hexadecimals to Decimals (x,yz) values and plot them. The sampling rate(0,1 = 10 values per second) and the offset of the chart are given through the property node of the Chart.

I also convert the time stamp to Excel format ( e.g 36000,5 = 36000 days after the date 01.01.1900 and after the comma is the time 0,5 = 12:00:00 AM)

So now , I want to save the values in an Excel sheet with its time stamp.

How can I solve this problem?

pls see my code to get my points.

Hello,

is it possible that I see milliseconds in the time stamp?

e.g 12:10:30,100

I ask this since I am plotting a chart with 2 variables over time a-axis which looks like this:

x1,y1, time

x2,y2, time+100 ms

x3,y3, time+200 ms

...

...

x1000000,y1000000, time + 100.000 sec

e.g

100,102, 1,5000000 (1,5 is the Excel interpretation of the time which means 1 day 12 hours after 01.01.1900)

100,102, 1,500000001

so as you see I have 10 plots in a second and I want to record each row in a .CVS or Excel sheet. I couldn`t find millisecond interpretation , I guess it doesn`t exist in LV 7.1 ?!

The second point I want to ask is , I managed to convert the LV time, to Excel Decimal format (e.g 3600,512342 == 10.10.2006 12:17:46)

Now I want to save them in .CVS or EXCEL format, X,Y,and time values are arrays , how do you advise me to save them in excel file? and what is with milliseconds?

Thanks in advance...

silver

QUOTE(Jim Kring @ Feb 23 2007, 10:49 PM)

This is not a bug, it's a feature. Here's what's up...

There are two types of "time" absolute time and relative time. The timestamp is an absolute time datatype and a floating point is (or should only be used for) relative time.

Subtracting two absolute times results in a relative time: 2/23/2007 - 2/21/2007 = 4147200.000 seconds (2 days).

Whaaaaaaaaaaaat? 1 hour = 3600 sec. , 24 hours (1 day) = 86400 sec , 2 DAYS = 172800 seconds

my friend

Subtracting two relative times results in a relative time: 3.0 seconds - 0.8 seconds = 2.2 seconds

Adding two relative times is nonsensical: tomorrow + today = huh? (unless you're living in one of alpha's parallel universes)

Adding a relative time to an absolute time results in an absolute time: 2/23/2007 21:00:00 + 5.0 seconds = 2/23/2007 21:00:05