Reading time from the year numbers, day numer and hour number

Hi everyone! How to extract the time from the year number, day number and hour number and combine them into single date time. Example yyyy-mm-dd HH:MM:SS.

Here is one of the sample data:

yearnumber=2019.24917302
day_number=91.19733;
hour_number=4.73580;

[Jan]

What is the wanted output? Should we assume, that in 2019.24917302 the fractional part is the fraction of the complete year inlucding leap days? Does the farctional part of 91.19733 mean the second 0.19733 * 86400?

[Vijay Sagar]

Sir, the output is :

2019-05-02 04:44:00

Yes, It is ractional part is the fraction of the complete year inlucding leap days. I also don't know wheather it is a fractional part of 91.19733. The answer given by @Star Strideris correct.

Answer 1

[Star Strider]

I cannot find a way using the MATLAB date and time functions to convert these automatically.

Try this —

year_number=2019.24917302;
day_number=91.19733;
hour_number=4.73580;

Convert = @(year_number,hour_number,day_number) datetime([fix(year_number) fix(rem(year_number,1)*12) fix(day_number) fix(hour_number) fix(rem(hour_number,1)*60) 0]);
Out = Convert(year_number,hour_number,day_number)

Out = datetime
   02-May-2019 04:44:00

.

[Vijay Sagar]

Sir, Thank you so much. It is helpful.

[Star Strider]

As always, my pleasure!