02-08-2011 04:45 AM
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...
02-08-2011 09:18 AM
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