I have data with dates and times in separte columns. How do I put them together into a datetime format?

Question

Timothy Potter 2019-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/448172-i-have-data-with-dates-and-times-in-separte-columns-how-do-i-put-them-together-into-a-datetime-form

回答： Timothy Potter 2019-3-11

采纳的回答： Peter Perkins

I have data with dates and times in separate columns. How can I get them combined into a single datetime stamp column?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Jan 2019-3-6

And what is the wanted result? A Matlab array or table object, another CSV file?

Please add the required details. The readers cannot guess, what you want to do.

Timothy Potter 2019-3-6

I wanted a Matlab array against which to plot data. I figured out how to do it by seaching other answers and trial and finally success.

%first they had to be converted to numbers,

dateDt1031 = datetime(Verif181031.Date);

timeDt1031 = Verif181031.Time;

% And then added ( I also subtracted the starting time.).

timeStp1031 = (dateDt1031-strt) + timeDt1031;

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2019-3-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/448172-i-have-data-with-dates-and-times-in-separte-columns-how-do-i-put-them-together-into-a-datetime-form#answer_364835

Timothy, in recent versions of MATLAB (since R2018a, IIRC), readtable should read those two columns as a datetime and a duration, and you can just add them. Prior to that, you'lll have to read the times in as text and convert to duration. You can use this File Exchange post. After that, just add o the datetime.

But it looks like maybe you got there on your own!