LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Real time vs data (from lab view to excel)

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.

0 Kudos
Message 1 of 8
(3,046 Views)

Hi,

What is the function you are using to derive time and log into spreadsheet? Can you just post a snap shot of it?

With regards,
JK
(Certified LabVIEW Developer)
Give Kudos for Good Answers, and Mark it a solution if your problem is solved.
0 Kudos
Message 2 of 8
(3,040 Views)

trd,

 

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 .

0 Kudos
Message 3 of 8
(3,028 Views)

Hi,

 

search the forum for "excel timestamp conversion", there are functions available for conversion between LV and Excel...

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 4 of 8
(3,024 Views)

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.

Jim

LV 2020
0 Kudos
Message 5 of 8
(3,018 Views)

Hi guys. thanks for ur replies. here r a few screen shots of the block diagram, front panel and the excel output.

Download All
0 Kudos
Message 6 of 8
(2,996 Views)

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.

0 Kudos
Message 7 of 8
(2,962 Views)

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.

0 Kudos
Message 8 of 8
(2,946 Views)