Hi Philip, The xlsreadwrite toolbox yields formatted dates in the string field. You should give it a try.
S. > Le 5 nov. 2021 à 10:43, P M <[email protected]> a écrit : > > > Dear, > > thanks to the xls-link toolbox I am able to read data directly from an > xlsx-file. > > however, there is a strange data conversion going on: > > in the xlsx-file a column contains time data such as: > > 09:27:38 // this is a GMT value > > result after reading the data into Scilab is like this > 0,394189814814815 > > It is possible to get the hh:mm:ss back from this, like: > > 0.394189814814815 * 24 = 9.4605556 --> 9 = hours value > 0.4605556 * 60 = 27.63336 --> 27 = minutes value > 0.63336*60 = 38.0016 --> 38 = seconds value > > or: > > seconds = 0.394189814814815 * 24 * 60 * 60 ; > date = getdate( seconds ) > - however > --> the date would be wrong > --> which is obvious, because the initial value does not indicate a > specific day > > --> the time would have to be corrected for daylight saving time (summer > time) if necessary > --> result is 10:27:38 > > My question is: > Why is the extract from the xls file not intially in human readable format? > Is it, because EXCEL internally stores the time value in a decimal fashioned > way and only displays in human readable format? > > Thank you, > Philpp > > > > _______________________________________________ > users mailing list > [email protected] > http://lists.scilab.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.scilab.org/mailman/listinfo/users
