Hi Stéphane, That works. Thanks for the hint.
Best Regards, Philipp Am Fr., 5. Nov. 2021 um 14:15 Uhr schrieb Stéphane Mottelet < [email protected]>: > 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 >
_______________________________________________ users mailing list [email protected] http://lists.scilab.org/mailman/listinfo/users
