Creating a Timetable from a large excel data set

I have only have basic matlab training- and that has been a while- and I am currently struggling on manipulating this large data set.

I am trying to turn this data set into a timestable. However, I get an error code saying that I need a datetime or duration vector. I attempted to create a datetime but I haven't found a way to do that where I don't have to type everything in individually.

My other problem- my time data (day, month, year, hour, minute, second) is all in a single column. So I am not sure how to break apart the data, again without doing every individual term.

[Mikayla]

[Mikayla]

[Mikayla]

Answer 1

[MJFcoNaN]

Hello,

What type is the AbsTime? Does this one work?

t=table2timetable(m137);

[Mikayla]

No that doesn't work. One of the pictures I posted in the comments showed that I had tried that and that is where I got the error code of needing a datetime or duration variable.

I don't know about the type of Abstime. It's formatted into a single column of month/day/year hour:minute.

I separated this data out into multiple columns in excel but still can't figure out how to make a datetime.

[MJFcoNaN]

Sorry, I don't find in which picture you tried the code ("m137" as the input of table2timetable) and the consequent error.