different excel version time convert problem

1 次查看（过去 30 天）

davit petraasya 2016-10-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305851-different-excel-version-time-convert-problem

评论： davit petraasya 2016-10-13

Hi all

I was using excel 2007 version and Matlab2010 on my windows. I have excel table and for importing time I was using datenum(such as datenum('25/05/1970','dd/mm/yyyy')) function. It was working perfectly.

Now I changed my excel version 2015 and Matlab 2016 working on Mac. Now this excel version understanding my times as 25654, 25754...

How I can convert time?

Thanks!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Marc Jakobi 2016-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305851-different-excel-version-time-convert-problem#answer_237469

You may have to check the language setting or the formatting of the date on your mac

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

davit petraasya 2016-10-13

Thank Marc, yes it seems it was formatting problem.

请先登录，再进行评论。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 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