Hi everyone.i am just working on getting voltages from temperature and heartrate sensor.
I m able to plot them on XY chart against actual. But when i try to save the data onto excel the time goes into 3.833 X10^9 form in excel which has something to do with the timestamp in labview. Can you please help how to get the actual time even in excel.
When transfering data into Excel, it is often necessary to format the cells for the type of data. This is especially true with time stamps. An example that uses the 'format string' can be found here .
It is easier to get good help if you post the code you have along with your question, or at least a pic of the section of code you are struggling with.
Since you are not writing to an Excel file and converting a timestamp to a numeric, you will have to calculate the difference between LabVIEW's time reference and Excel's (do the above mentioned search). In Excel, you will then have manually chage the format of the imported column.
Be aware that Excel timestamps do not have as much resolution as LabVIEW timestamps. Depending on your needs, you may want to break the LabVIEW timestamp into multiple columns (e.g. date, time, seconds) for use in Excel.
