I have a n X 6 matrix, with time data:
1st col = yyyy (e.g. 2016)
2nd col = mm (e.g. 10 for Oct)
3rd col = day (e.g. 1)
4th col = hour
5th col = min
6th col = seconds
I need to combine them into a n X 1 (e.g. 1-Oct-2016 00:00:00). How can I do that?
My initial data comes in the form of serial date (e.g. 4.264400001156250e+04 for 1-Oct-2016 00:00:00)
I used this function to convert into a date vector, but am stuck from here:
date_vec = datevec(datestr(x2mdate(raw_data)));
Should I be doing this? My goal is to export to excel for it to be read properly (need to plot a time series). Currently when it goes to the next day, instead of showing up the date of the next day, it simple wraps back to AM of the same day.