Import correct date and time from different columns in Excel

Question

Daphne PARLIARI 2020-1-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500303-import-correct-date-and-time-from-different-columns-in-excel

评论： Star Strider 2020-1-16

采纳的回答： Star Strider

Airport 2019 (1.5-30.9).xlsx

Hi guys!

I have several excel files I want to access in matlab and of course one of the problems is date and time.

I am attaching one .xlsx in order for you to understand: I must combine columns B,C and D to get the date and column E is time (0 means 00:00, 1 means 01:00 etc).

Therefore the first raw of my data express the date and time 1/5/2019 (May 1st, 2019) at 00:00.

If I try this

obsdata(:, 2) = round(obsdata(:, 2)) ;

obsdata(:, 3) = round(obsdata(:, 3)) ;

obsdata(:, 4) = round(obsdata(:, 4)) ;

obsdata(:, 5) = round(obsdata(:, 5)) ;

Date = datetime(obsdata(:, 2), obsdata (:, 3), obsdata(:,4), obsdata(:,5), 0 ,0)

it doesn't work. Date appears messed up...

Any ideas please?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2020-1-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500303-import-correct-date-and-time-from-different-columns-in-excel#answer_410162

在 MATLAB Online 中打开

Try this:

In = readtable('Airport 2019 (1.5-30.9).xlsx', 'PreserveVariableNames',1);
hrmnsc = datetime(compose('%04d\n',In.Time), 'InputFormat','HHmm', 'Format','HH mm ss');
DVhms = datevec(hrmnsc);
DatesTimesDV = [table2array(In(:,2:4)), DVhms(:,4:6)];
DatesTimes = table(datetime(DatesTimesDV), 'VariableNames',{'DatesTimes'});
Airport = [In(:,1) DatesTimes In(:,6:end)];