Numeric array to serial datetime

3 visualizzazioni (ultimi 30 giorni)
Annika
Annika il 29 Set 2022
Risposto: Star Strider il 29 Set 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)

Risposta accettata

Star Strider
Star Strider il 29 Set 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
.

Più risposte (0)

Categorie

Scopri di più su Data Type Conversion in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by