How to Convert this time series data to YYYY-MM-DD HH:MM format
7 次查看(过去 30 天)
显示 更早的评论
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
![addd.JPG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/227712/addd.jpeg)
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.
0 个评论
回答(2 个)
dpb
2019-7-5
编辑:dpb
2019-7-6
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.
0 个评论
Star Strider
2019-7-5
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
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!