Numeric array to serial datetime

1 view (last 30 days)
Annika
Annika on 29 Sep 2022
Answered: Star Strider on 29 Sep 2022
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)

Answers (1)

Star Strider
Star Strider on 29 Sep 2022
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
.

Categories

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

Community Treasure Hunt

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

Start Hunting!