- Know precisely how you have it, and
- Don't have to make something to hopefully match but can use what is provided directly.
Transform into a Matlab datetime format, Part 2 (Sample File Attached)
1 view (last 30 days)
Show older comments
I have a column of MM_DD_YY and another column with hours (1 to 24). What is the best way to concatenate two entries to apply datetime? Thank you.
2 Comments
dpb
on 14 Jun 2018
Again, make it easier for folks to help...supply a short snippet of actual data so
dpb
on 14 Jun 2018
Attached file shows why precisely; the TITLE for the date column says MM_DD_YY but that is not how the data are stored; they're mm/dd/yyyy instead so a solution to the original question wouldn't work.
Point being not to criticize but to improve chances of getting correct answers without a lot of back-and-forth by supplying needed info up front. Remember we know only what you tell or show us; we can't see your terminal and we don't know what you've done so far...
Accepted Answer
Star Strider
on 14 Jun 2018
Try this:
TestTbl = readtable('Test.csv');
DT = datetime(TestTbl{:,1}, 'InputFormat','MM/dd/yyyy', 'Format','MM/dd/yyyy HH:mm');
DT = DT + hours(TestTbl{:,2})
DT =
2×1 datetime array
12/01/2017 01:00
12/01/2017 02:00
2 Comments
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!