excel timestamps vs matlab
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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
0 Commenti
Risposta accettata
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets 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!