Effacer les filtres
Effacer les filtres

excel timestamps vs matlab

1 vue (au cours des 30 derniers jours)
Trevor Harris
Trevor Harris le 28 Oct 2016
Commenté : Trevor Harris le 28 Oct 2016
Hello all,
I have an excel sheet with time stamps that I want to bring into matlab. Seems as if the two have different conventions for time. While I can correct this numerically, I was wondering if someone could confirm this for me.
The time stamp 42549.9993055556 in excel converts to 6/28/16 23:59 (by changing the number format). Which is actually the correct time that I'm looking for. However, calling datestr(42549.9993055556) says the date is 29-Jun-0116 23:59:00. Obviously the wrong year. Is there something I'm missing?
Thanks! Trevor

Connectez-vous pour répondre à cette question.

Réponse acceptée

dpb
dpb le 28 Oct 2016
  1 commentaire
Trevor Harris
Trevor Harris le 28 Oct 2016
Great, thanks!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by