I am trying to record time during my measurements but can not see values in Excel

[nightingale]

I am not very familiar with Labview yet and trying to record some pressure values, flow rates versus time. However, when I save the values and open the output Excel file, I can not see the correct time and date values. Both time and date formats are not correct. In the attachment, I am sending the view of the block diagram, front panel and the Excel file I obtained.

I will be very glad, if you could give some suggestions.

Thanks in advance.

S

[Rod42]

Hi,

I'm assuming that you are writing to the file as text.

The first thing I'd check is the cell formatting in Excel. I ran a quick check of using the "write to measurement file" express vi to write an empty dataset to a text file and saw the data and time looking wrong. A quick check in Exvcel showed that the data in an unexpected format, but appropriate use of Excel's "format cells" fixed it.

Rod.

[Rod42]

PS

For your application, write to measurement file is probably not the best way of writing the data.

It's very hard to see what's going on when you use express vis, have wires entering and leaving objects at other than the terminals, and you only shows us a screen dump.

Rod.

[NIquist]

This may help:  http://digital.ni.com/public.nsf/allkb/04BA60F0C2DE768A86256CED007E528B

[JÞB]

---

@nightingale wrote:

I can not see the correct time and date values. Both time and date formats are not correct. In the attachment, I am sending the view of the block diagram, front panel and the Excel file I obtained.

I will be very glad, if you could give some suggestions.

S

---

Excel and LabVIEW keep time differently.  You will need to translate the value LabVIEW uses as time to the value Excel uses as time. 

Here is a good routine: