09-22-2017 05:21 AM
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 ?
09-22-2017 05:43 AM
09-22-2017 05:54 AM
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
09-22-2017 06:09 AM - edited 09-22-2017 06:11 AM
Hi bhuvanesh,
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:
09-22-2017 06:26 AM
Hi gerdw ,
I don't want to change the format in excel sheet . how I read programmatically in LabVIEW correctly. ??
09-22-2017 06:34 AM
09-22-2017 06:52 AM
Hello gerdw ,
different formatting means ?? i need a time as it like in excel . guide me with screenshot
09-22-2017 08:32 AM
Hi bhuvanesh,
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"…
09-23-2017 01:24 PM
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.
Bob Schor