Sorting data from time stamp in excel
2 次查看(过去 30 天)
显示 更早的评论
I have data in excel that has two columns and 3,000 rows. The first column is date and time in the format month/date/year hour:minute:secondAM/PM. I'm trying to load this data into matlab and put the year, month, date and time in separate columns so I end up with five columns.
I can use the load function to get the excel data into matlab but I'm not sure how to separate the time stamp data into different columns.
0 个评论
回答(1 个)
dpb
2014-7-1
Why do you need separate columns--what are you going to do with them?
If you think you must, use datevec to parse the string format.
doc datevec
doc datenum
Read the section under data import/spreadsheets on converting Excel date values for background working with Excel dates other than text.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!