# Create a numeric variable with date+hour

조회 수: 1(최근 30일)
David E.S. 2021년 2월 11일
댓글: David E.S. 2021년 2월 11일
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
##### 댓글 수: 2표시숨기기 이전 댓글 수: 1
David E.S. 2021년 2월 11일
I don't know how to merge both columns in order to create other which have date + space + hour.

댓글을 달려면 로그인하십시오.

### 채택된 답변

Steven Lord 2021년 2월 11일
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표시숨기기 없음
David E.S. 2021년 2월 11일
Excellent explanation, very useful. Thanks!!

댓글을 달려면 로그인하십시오.

### Community Treasure Hunt

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

Start Hunting!

Translated by