different excel version time convert problem

2016 10 5
1 个回答
回答已采纳
更新时间：2016 10 13
6 次查看（30 天）

0 个投票

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!

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

 采纳的回答

Marc Jakobi
Marc Jakobi 2016-10-5

0 个投票

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

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by