different excel version time convert problem

1 visualizzazione (ultimi 30 giorni)

davit petraasya il 5 Ott 2016

0
Link

Link diretto a questa domanda

https://it.mathworks.com/matlabcentral/answers/305851-different-excel-version-time-convert-problem

Commentato: davit petraasya il 13 Ott 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!

0 Commenti
Mostra -2 commenti meno recentiNascondi -2 commenti meno recenti

Accedi per commentare.

Accedi per rispondere a questa domanda.

Risposta accettata

Marc Jakobi il 5 Ott 2016

0
Link

Link diretto a questa risposta

https://it.mathworks.com/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 Commento
Mostra -1 commenti meno recentiNascondi -1 commenti meno recenti

davit petraasya il 13 Ott 2016

Thank Marc, yes it seems it was formatting problem.

Accedi per commentare.

Più risposte (0)

Accedi per rispondere a questa domanda.

Categorie

Computational Finance Spreadsheet Link Data Import from MATLAB

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by