merging date and time columns in a timetable

16 views (last 30 days)
I have .csv file with two separate columns one for date and one for time. I am trying to import them both in a single field in a timetable and use them as rowtimes. Any pointers?
Date Time
____ ______
06/07/2020 17:00:01
06/07/2020 17:00:02
06/07/2020 17:00:03

Accepted Answer

Walter Roberson
Walter Roberson on 4 Jul 2020
tt = table2timetable( YourTable, 'RowTimes', datetime(YourTable.Date) + duration(YourTable.Time) );

More Answers (1)

Akram Hussein
Akram Hussein on 4 Jul 2020
Thank You. I had to do just a tweak in formatting to make it work. So posting the code for others. The time format i was using was 'MM/dd/yyyy HH:mm:ss' and had to be specified. Further t.Date is of type datetime and t.Time is of type duration
t = readtable(filename);
tt = table2timetable( t, 'RowTimes', datetime(t.Date + t.Time,'Format','MM/dd/yyyy HH:mm:ss') );

Categories

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

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!