Create a numeric variable with date+hour

Hi. I have a problem when I want to create a numeric variable which contains date + hour. This is my data:

So... I want to obtain a number with the sumatory by rows (both columns are strings). Can you help me?

Thanks!

MATLAB VERSION: R19b

[Paresh yeole]

https://de.mathworks.com/help/matlab/matlab_prog/convert-between-datetime-arrays-numbers-and-strings.html#bth57tm-1

[David E.S.]

I don't know how to merge both columns in order to create other which have date + space + hour.

Answer 1

[Steven Lord]

How are you planning to use this "numeric variable with date+hour"? It's quite likely that you can achieve your goal with a datetime array.

dateAndTime = ["19/11/19", "05:16:41"; "19/11/19", "05:19:03"; "19/11/19", "05:21:26"]

dateAndTime = 3×2 string array
    "19/11/19"    "05:16:41"
    "19/11/19"    "05:19:03"
    "19/11/19"    "05:21:26"

dATWithSpace = join(dateAndTime, " ")

dATWithSpace = 3×1 string array
    "19/11/19 05:16:41"
    "19/11/19 05:19:03"
    "19/11/19 05:21:26"

dt = datetime(dATWithSpace, 'InputFormat', 'dd/MM/yy hh:mm:ss')

dt = 3×1 datetime array
   19-Nov-2019 05:16:41
   19-Nov-2019 05:19:03
   19-Nov-2019 05:21:26

For example, you can plot with it.

plot(dt, [1 4 9], 'o-')

[David E.S.]

Excellent explanation, very useful. Thanks!!