How to Convert this time series data to YYYY-MM-DD HH:MM format

Dear expert,

I want to convert time series data I have in the form of hhmm and want tot convert to hh:mm format. Here is how the data looks like

I want to cobine the 3 columns. First is year. 2nd is no of day from 1st jan. 3rd is HHMM. I want YYYY-MM-DD HH:MM or something similar.

Answer 1

[dpb]

dt=datetime(Year,1,day,fix(time/100),mod(time,100),0);

ADDENDUM:

Using Star's array...

A = [2019 137 1650; 2019 144 1740]; 
Year=A(:,1);day=A(:,2);time=A(:,3);
dt=datetime(Year,1,day,fix(time/100),mod(time,100),0);

>> dt
dt = 
  2×1 datetime array
   17-May-2019 16:50:00
   24-May-2019 17:40:00
>>

And, of course, you don't need to make the intermediate variables, just pass the subarrays.

Answer 2

[Star Strider]

Try this:

A = [2019 137 1650; 2019 144 1740];                                                         % Two Sample Rows
S = num2str(A);                                                                             % Strings
DT = datetime(S, 'InputFormat','uuuu DDD HHmm', 'Format','yyyy-MM-dd HH:mm')                % Convert To ‘datetime’

producing:

DT = 

  2×1 datetime array

   2019-05-17 16:50
   2019-05-24 17:40