excel timestamps vs matlab

1 visualización (últimos 30 días)
Trevor Harris
Trevor Harris el 28 de Oct. de 2016
Comentada: Trevor Harris el 28 de Oct. de 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

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

dpb
dpb el 28 de Oct. de 2016

Más respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by