Create a numeric variable with date+hour

1 view (last 30 days)
David E.S.
David E.S. on 11 Feb 2021
Commented: David E.S. on 11 Feb 2021
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-')
  1 Comment
David E.S.
David E.S. on 11 Feb 2021
Excellent explanation, very useful. Thanks!!

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!