LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Time from .xls file is divided

Hello I,m new with LabVIEW 10 and i have a problem with reading time from .xls file with the read excel values.vi

 

In excel the time format is  00:00:20     but in LabVIEW (with Strings) i get (i think) a divided result 0,000231481481481481 for 00:00:20 and so on.

        00:00:15

00:00:20

00:00:17

00:00:20

00:00:08

00:00:20

00:00:09

 

I would like to get the same format in the .vi as it is in .xls file.

Picture added.

 

Could you please helpe me with this...

0 Kudos
Message 1 of 2
(2,190 Views)

That VI returns the value of the cell, not the formatted string. The issue with time values between Excel and LabVIEW has been brought up numerous times before. Excel does not use the same datetime starting point as LabVIEW. See, for example, this discussion: http://forums.ni.com/t5/LabVIEW/Read-custom-excel-time-data-in-LabView/m-p/775359

0 Kudos
Message 2 of 2
(2,158 Views)