Create a numeric variable with date+hour

1 view (last 30 days)
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

Accepted Answer

Steven Lord
Steven Lord on 11 Feb 2021
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-')

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!