converting column of datetimes in excel to datenumbers in matlab

3 次查看（过去 30 天）
Jubilee Sibanda
Jubilee Sibanda 2020-7-13
编辑： Mehmed Saad 2020-7-15
hie everyone
I want to convert data in column C (labeled datetime) of the attached document to a column of date numbers in matlab, which are to be used as input variables for a neural network
please help

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

采纳的回答

Mehmed Saad
Mehmed Saad 2020-7-13
编辑：Mehmed Saad 2020-7-13
T = readtable('zetdctestdata.xlsx');
T.datetime = cellfun(@(x)datenum(x,'mm/dd/yyyy HH:MM:SS'),T.datetime);
  5 个评论
显示 3更早的评论
Jubilee Sibanda
Jubilee Sibanda 2020-7-14
and how do i stop matlab from rounding off the outputs in the columns i get 7.3708e+05 instead of 737076.458333333
Mehmed Saad
Mehmed Saad 2020-7-15
编辑：Mehmed Saad 2020-7-15
Actual value in variable is 737076.458333333 but due to format it is rounding off
The default format for command window is Short
T.datetime(1)
ans =
7.3708e+05
Change Format to long
format Long
T.datetime(1)
ans =
7.370764583333334e+05
But it is just for display purpose

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by