different excel version time convert problem

1 Ansicht (letzte 30 Tage)
davit petraasya
davit petraasya am 5 Okt. 2016
Kommentiert: davit petraasya am 13 Okt. 2016
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!

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Marc Jakobi
Marc Jakobi am 5 Okt. 2016
You may have to check the language setting or the formatting of the date on your mac

Weitere Antworten (0)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by