From date and time in different columns to datetime

6 次查看（过去 30 天）
Espen Mikkelsen
Espen Mikkelsen 2018-3-20
评论： Peter Perkins 2020-7-28
Hey, I have an array with date (yyyy-mm-dd) in one columns and time (hh:mm:ss) in another like this:
2017-09-29 21:00:00
2017-09-29 22:00:00
2017-09-29 23:00:00
2017-09-30 00:00:00
2017-09-30 01:00:00
2017-09-30 02:00:00
2017-09-30 03:00:00
How can I make this array into a datetime array?
  1 个评论
Andrei Bobrov
Andrei Bobrov 2018-3-20
编辑：Andrei Bobrov 2018-3-20
Please attach an example of your data (as mat-file) so that we know what type of data you are using.

请先登录，再进行评论。

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

采纳的回答

Akira Agata
Akira Agata 2018-3-20
Assuming your data is stored in CSV file like the attached, readtable function automatically recognize that 1st and 2nd column are datetime and duration. So, the following can make the datetime vector you want.
T = readtable('data1.csv');
time = T{:,1}+T{:,2};
  7 个评论
显示 5更早的评论
Felix123
Felix123 2020-7-21
@Peter Perking: can you be more specific on how to adjust these. I have not ever had a spreadsheet, where this was figured out automatically.
Peter Perkins
Peter Perkins 2020-7-28
It's described in the examples here:
https://www.mathworks.com/help/matlab/ref/detectimportoptions.html
If a recent version of readtable (NOT xlsread) can't automatically identify date columns, then there's something in the spreadsheet that's not "right". The cells in the spreadsheet may not be formatted as dates. There may be a mix of text and other things. Hard to say for sure, but recent versions of readtable are pretty good at detecting dates.

请先登录，再进行评论。

更多回答（1 个）

Andrei Bobrov
Andrei Bobrov 2018-3-20
编辑：Andrei Bobrov 2018-3-20
datetime('2017-09-29') + hours(21:27)'

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by