Sorting data from time stamp in excel

10 次查看（过去 30 天）
Terez
Terez 2014-7-1
回答： dpb 2014-7-1
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.

请先登录，再回答此问题。

回答（1 个）

dpb
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.

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by