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.
|TCS TH TANK1 TOP||TCS TH TANK1 BOT|
|Param Description||Date/Time(Z)||PT1 (TM)||Deta-P|
|2020-07-17T08:11:00||17.07.2020 08:11:00||17.7.20 8:11||2.092874|
|2020-07-17T08:21:00||17.07.2020 08:21:00||17.7.20 8:21||2.089911||3.2421|
|2020-07-17T08:31:00||17.07.2020 08:31:00||17.7.20 8:31||2.089911||3.2387|
|2020-07-17T08:41:00||17.07.2020 08:41:00||17.7.20 8:41||2.089911||3.2354|
|2020-07-17T08:51:00||17.07.2020 08:51:00||17.7.20 8:51||2.089911||3.2320|
|2020-07-17T09:01:00||17.07.2020 09:01:00||17.7.20 9:01||2.110652||3.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
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