Time format and conversion

I'm new to Scilab although, in the past, I've used MatLab for data processing and plotting so there will probably be a number of questions from me in the future if I cannot find anything under Scilab or e.g. in this forum.

Now, I've managed to create the necessary plots but I've problem with the time format. The Telemetry data from the satellite can be formatted in various ways, two examples are shown below.

17.10.2002 00:00:007070
17.10.2002 01:00:007070
17.10.2002 02:00:007070
17.10.2002 03:00:0018.846153818.0769231
17.10.2002 04:00:0021.666666718.0769231
17.10.2002 05:00:0024.583333318.8461538


Param DescriptionDate/Time(Z)PT1 (TM)Deta-P
2020-07-17T08:11:0017.07.2020 08:11:0017.7.20 8:112.092874
2020-07-17T08:21:0017.07.2020 08:21:0017.7.20 8:212.0899113.2421
2020-07-17T08:31:0017.07.2020 08:31:0017.7.20 8:312.0899113.2387
2020-07-17T08:41:0017.07.2020 08:41:0017.7.20 8:412.0899113.2354
2020-07-17T08:51:0017.07.2020 08:51:0017.7.20 8:512.0899113.2320
2020-07-17T09:01:0017.07.2020 09:01:0017.7.20 9:012.1106523.2286

As far as I can see, Scilab reads the Excel date/time and convert it to a real value, but converting it back to a "proper" date, I get somethin that is not really useable. I've been playing around with Scilab functions a little but I've not really found out what format Scilab use. As an example, the date/Time

17.10.2002 11:00:00 is converted to 37546.458333 in Excel. If this is coverted back to a date format in Scilab, I get

--> datevec(37546.458333)
ans =

102. 10. 18. 10. 59. 59.9712

I.e. 1 day and 1900 years off. Eventually I want to use the correct date, e.g. expressed as 20.01.2002 for the x-axis of my plots.

However, the first question, how do I convert the real value or a date into a correct date format, e.g. DD.MM.YYY hh.mm.ss

Scilab 18-11-20, 1:40 a.m. TommyS

Log-in to answer to this question.