convert date time to number ?

Question

MUKESH KUMAR 2018-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408725-convert-date-time-to-number

评论： Aarti Dwivedi 2018-7-6

I had excel sheet having date format dd/mm/yyyy hh:mm:ss , So now I want to convert each value into number format. How can I do this?

2 个评论
显示无隐藏无

Walter Roberson 2018-7-4

Which number format is it?

Does the spreadsheet have the values stored as text string or as excel date format?

Stephen23 2018-7-4

编辑：Stephen23 2018-7-4

Using datetime, datenum, or datevec, depending on your need. What have you tried so far?

请先登录，再进行评论。

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

Answer 1

Aarti Dwivedi 2018-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408725-convert-date-time-to-number#answer_327434

在 MATLAB Online 中打开

https://www.mathworks.com/help/matlab/ref/datenum.html Assuming that you have already read the values from the Excel sheet in different variables, the number you are looking for is "numd", it can be obtained using:

date_arr = datetime(yyyy,mm,dd,hh,mm,ss)
numd = datenum(date_arr)

2 个评论
显示无隐藏无

Peter Perkins 2018-7-5

Unless you specifically need a datenum, this is almost certainly not the best choice. As Walter says, what number format do you need?

And in any case, in recent versions of MATLAB, you can read dates from Excel directly as datetimes, and it's likely that you do not need to convert them to a "number".

Aarti Dwivedi 2018-7-6

The OP wanted a "number", that's why I provided it. Although I agree with you that it is not the best choice, I put it with datetime as well as datenum so that it would be clear to a MATLAB novice and the OP the difference between the two.

请先登录，再进行评论。