清空筛选条件
清空筛选条件

excel timestamps vs matlab

1 次查看（过去 30 天）
Trevor Harris
Trevor Harris 2016-10-28
评论： Trevor Harris 2016-10-28
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

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2016-10-28

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by