How to convert date and time present in same cell to a matrix having all values in elongated form like Y, M, D, H, Mi, S?

Question

Saad Ahmed 2018-10-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421563-how-to-convert-date-and-time-present-in-same-cell-to-a-matrix-having-all-values-in-elongated-form-li

回答： Peter Perkins 2018-10-1

date and time.xlsx

I have an excel file of time and want to convert the time values to datevec format. The format of time in excel file is like '1/17/2018 16:20:37', '1/17/2018 16:25:37' and so on. I want these values in this format: year, month, date, hour, minutes and seconds. Also, when I read the xlsx file in MATLAB, it automatically converts time to 12 h format like 4:20:37 pm. Please help.

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

请先登录，再进行评论。

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

Answer 1

JohnGalt 2018-10-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421563-how-to-convert-date-and-time-present-in-same-cell-to-a-matrix-having-all-values-in-elongated-form-li#answer_339190

在 MATLAB Online 中打开

datevec(datestr('1/17/2018 16:20:37','dd/mm/yyyy HH:MM:SS'))

and more generally

dts  = {'1/17/2018 16:20:37', '1/17/2018 16:25:37'}
datevec(datestr(dts,'dd/mm/yyyy HH:MM:SS'))

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Saad Ahmed 2018-10-1

Yeah, it works. Thanks.

请先登录，再进行评论。

Answer 2

Peter Perkins 2018-10-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421563-how-to-convert-date-and-time-present-in-same-cell-to-a-matrix-having-all-values-in-elongated-form-li#answer_339260

在 MATLAB Online 中打开

I'm gonna suggest that you likely don't need to do this. Unless you are using a pretty old version of MATLAB, use datetime instead of datenum/datevec/datestr.

If you want, for example, the hour field, it's simple to get it from a datetime when you need it:

>> t = datetime({'1/17/2018 16:20:37', '1/17/2018 16:25:37'})
t = 
  1×2 datetime array
   17-Jan-2018 16:20:37   17-Jan-2018 16:25:37
>> t.Hour
ans =
    16    16

Also, you should probably be using readtable to get the timestamps and whatever else is in the spreadsheet into MATLAB. It will make life much easier.