How to convert to datenumber from two cell values

    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

[Michael Madelaire]

Can you provide the content of "tmp"? Just an example.

[Jan]

You forgot to tell us the contents of date and time. What is the contents of

tmp{1}{1}, tmp{1}{2}

? Maybe you forgot the space character at the center?

[Duncan Wright]

My apologies,

tmp is a cell structure of my data.

tmp{1}(1) = 26:05:2017 tmp{1}(2) = 16:05:30

I.e. date and time.

[Jos (10584)]

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

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

[Jan]

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.

Answer 1

[Peter Perkins]

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

[Duncan Wright]

Thanks for the tip!