Is it possible to import an excel sheet with date&time and separate sheets by date

I have multiple monthly excel sheets each having a big number of columns and rows. The first column of each sheet contains the date and time for data taken every 5 mins for a month period. Is it possible that I import the sheet on matlab and save in different sheets for each day?

[madhan ravi]

upload your file

[Stefan Azzopardi]

This is an example of 3 days but I have similar for each day and for several months. I need to save 01/09/2018 on one excel sheet, 02/09/2018 on another sheet etc

Answer 1

[dpb]

Sure, just read in and use the datetime data to group by day. See very similar Q? asked here Split data for each date

Note there are two ways to "skin the cat" there; one using a timeseries object and another just using the datetime data directly.

[Stefan Azzopardi]

To be honest I have found that post previously but did not understand much of it. So the best way, correct me if I m wrong please, is to convert the table into a timetable and then try to use datetime dta directly?

[dpb]

Probably the better way is the second, but either will work...