converting date time string to double data

[GerdW]

Hi RJ,

there's a reason you're not allowed to upload BMP pictures - they are just huge. When converting your BMP to a real JPG it needs 170kb (high quality), converted to more suitable PNG it only needs 81kB - compared with your 3700kB upload!

It seems to me you want to use a function that doesn't provide the functionality you need. Maybe you need to program this using ActiveX?

Provide data in a format needed by Excel (as Darin explained) and format the X axis to show Date/Time instead of plain numbers...

[EvenDeejay]

Hi!

i do this alot when I'm creating testreports etc. I use ActiveX to get data from my program to Excel. I usually have the graphs on sheet 1 in the excel workbook. In sheet 2 i got all the datapoints from my program. My program adds data to sheet 2 for each object I'm measuring. In the the graphs in Excel automatically expand to use the newly added datapoints. This is an useful articly on how to create graphs in excel automatically. 

[RJ_15]

Though I dint convert the timestamp into double bt ya I successfully plotted my graph in Excel with that timestamp and data only.

No conversion, no coercion nothing.

Feeding the data into Excel from LabVIEW and plotting a chart with that data automatically.

Finally done and I forgot to mention used ActiveX.

🙂

Thnx and Regards

Runjhun A.

[falkpl]

I manipulate date time into numbers in 2 ways. 

1.  Subtract the to from the timestamp, now you will get a double numeric in seconds as a double.

2.  Use time seconds to date/time vi, this converts a timestamp to a cluster with each field representing each component of the timestamp in numeric,  I find this useful for making custom time number representations.

[JÞB]

Of course I'll post Time to XL.vi again

don't foget to vote for this idea