I have a date and time in two columns, where date is datetime and time is a string. I want to convert these to serial datetime and further combine them, after importing I changed the table to arrays:
DA = table2array(Feed(1,1))
TA = table2array(Feed(1,2))
then the time from string to number:
t = str2num(TA)
then the date to serial datetime:
sdt = datenum(DA)
How can I convert the time (number array) into serial datetime? (In excel its typed as ex. 14.45 (only hour + minutes)
(I know how to combine them)

 채택된 답변

Star Strider
Star Strider 2022년 9월 29일

0 개 추천

Perhaps something like this —
Feed{:,1} = datetime('29-Sep-2022');
Feed{:,2} = '14.45';
DT = Feed{:,1} + timeofday(datetime(Feed{:,2},'InputFormat','HH.mm'))
DT = datetime
29-Sep-2022 14:45:00
.

추가 답변 (0개)

카테고리

도움말 센터File Exchange에서 Dates and Time에 대해 자세히 알아보기

질문:

2022년 9월 29일

답변:

2022년 9월 29일

Community Treasure Hunt

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

Start Hunting!

Translated by