How to get yr, month, day, hr, min and s stored as separate variables from a serial date number?

1 次查看（过去 30 天）
Jing Ci Neo
Jing Ci Neo 2018-8-20
评论： Jing Ci Neo 2018-8-21
I have a vector of serial date numbers (such as 37987.0108217593) and I need to convert each one into year, month, day hr, min second. Example 37987.0108217593 would be year=2004, month=1, day=2, hour=0, min=29 and seconds=20. So I would have a vector called year, a vector called month etc.
Any help will be greatly appreciated!

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

采纳的回答

Steven Lord
Steven Lord 2018-8-20
That's close to what you get using the Excel datetime type, but not quite.
>> D = datetime( 37987.0108217593, 'ConvertFrom', 'excel')
D =
datetime
01-Jan-2004 00:15:35
When I paste that number into an Excel worksheet and format it as a Date, the result matches D rather than the information you posted.
If you really do need the datetime broken into its constituent parts you can use the datevec function on D, but there may be a way to achieve your ultimate goal without needing to perform this splitting. If you describe how you want to use this data we may be able to offer suggestions for how to achieve your goal without datevec.
  3 个评论
显示 1更早的评论
Steven Lord
Steven Lord 2018-8-20
Which release are you using? If you're using release R2013b or later, consider reading your data in using readtable instead of xlsread. If you do, depending on which release you're using you may be able to read the dates into a table directly from Excel using the 'DatetimeType', 'exceldatenum' name-value pair argument.
Jing Ci Neo
Jing Ci Neo 2018-8-21
I wasn't able to use readtable successfully but managed to manipulate the data in excel. Thanks for your help anyway! I really appreciate it.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by