Hello all ,
i have an attached a VI . which Consists of several rows and several columns. Particularly in a 3rd column ( Test time ) is not reading properly in LabVIEW indicator. i was tried in many ways ( extract a column and adding a colon ). what was the reason ?? how to crack this ?
change the column for this "Test Time" column from "time" to "scientific with 5 significant numbers" and you will notice you see the very same numbers as are shown in LabVIEW!
Hello Gerdw ,
i cant get you . shall we need to choose the whole column and change properties >??
in properties time editing option was not there . i am a beginner in this . plz post a screen shot of that and guide me
i cant get you .
I wanted to explain the LabVIEW readings: they are infact the very same numbers as in Excel!
shall we need to choose the whole column and change properties >??
Open your Sheet with Excel.
Select the Time column.
Change its format to scientific (with 5 sign. digits).
-> You will see the very same numbers as are shown in LabVIEW:
Hi gerdw ,
I don't want to change the format in excel sheet . how I read programmatically in LabVIEW correctly. ??
just apply a different formatting to this column - as is done in Excel…
Excel stores time values as fraction of days: "1e-3" equals 0.001d = 86.4s = 1m26.4s.
So all you need to do is to multiply the read time value by 86400 (seconds per day) and format the result using "%H:%M:%S"…
LabVIEW Date/Time (a.k.a. TimeStamps) are stored according to one algorithm, whereas Excel's "Serial Date" uses a different algorithm. It can make handling dates and times between the two systems a little tricky.