How to convert to datenumber from two cell values

3 次查看（过去 30 天）

Duncan Wright 2018-2-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/382900-how-to-convert-to-datenumber-from-two-cell-values

评论： Duncan Wright 2018-2-15

    date = cell2mat(tmp{1}(1))
    time = cell2mat(tmp{1}(2))
    dt = datenum([date time], 'dd:mm:yyyy HH:MM:SS')
    Error using datenum (line 181)
    DATENUM failed.
Caused by:
    Error using dtstr2dtnummx
    Failed to convert from text to date number.

What exactly am i doing wrong here?

Thanks in advance

5 个评论
显示 3更早的评论隐藏 3更早的评论

Jos (10584) 2018-2-15

在 MATLAB Online 中打开

As Jan already hinted at, add a space between date and time

str = [date ' ' time]
datum(str, 'dd:mm:yyyy HH:MM:SS')

Jan 2018-2-15

编辑：Jan 2018-2-15

在 MATLAB Online 中打开

What exactly is a "cell structure"? The explanation is not clear:

tmp{1}(1) = 26:05:2017

This is no valid Matlab syntax, therefore the readers have to guess, what it exactly means. Maybe it is a string object:

tmp{1}(1) = "26:05:2017"

Or a cell string:

tmp{1}(1) = {'26:05:2017'}

Please do not let us guess the details. I could post some code and test it, if you show us some valid Matlab code to create the inputs.

Are you sure that the date is written with colons? This is rather unusual.

请先登录，再进行评论。

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

采纳的回答

Peter Perkins 2018-2-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/382900-how-to-convert-to-datenumber-from-two-cell-values#answer_305375

在 MATLAB Online 中打开

In any case, if you are using a recent Version of MATLAB (R2014b or later), consider moving to datetimes, not datenums:

>> date = '26:05:2017';
>> time = '16:05:30';
>> dt = datetime([date ' ' time],'Format','dd:MM:yyyy HH:mm:ss')
dt = 
  datetime
   26:05:2017 16:05:30
>> dt = datetime([date ' ' time],'InputFormat','dd:MM:yyyy HH:mm:ss')
dt = 
  datetime
   26-May-2017 16:05:30