excel timestamps vs matlab
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Trevor Harris
am 28 Okt. 2016
Kommentiert: Trevor Harris
am 28 Okt. 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
0 Kommentare
Akzeptierte Antwort
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!