I have IgorTime data in which time:units = "seconds since 1904-01-01". I would like to convert this seconds to datevc.

7 visualizaciones (últimos 30 días)
I have attached the file (IgorTime).
Thank you

Respuesta aceptada

Walter Roberson
Walter Roberson el 18 de Jun. de 2019
datetime(T/86400,'convertfrom','excel1904')

Más respuestas (1)

Are Mjaavatten
Are Mjaavatten el 17 de Jun. de 2019
First: Are you sure your T vector is in seconds? If so, your time list covers about 48 milliseconds around 01-Jan-1904 11:41:29. It makes more sense if T is in days since 1904-01-01.
Anyway, here is a way to do it:
dt = datetime(1904,1,1) + T; % Use T/24/3600 if T is really in seconds
dv = datevec(dt);
I recommend to work with datetime objects, which are very flexible. For instance, the time axis adustst automatically when you zoom in plots.
  1 comentario
Vishnu Dhakad
Vishnu Dhakad el 18 de Jun. de 2019
I am sorry for wrong information.
By Mistake, I have uploaded the wrong file.
Now I am upload the correct file please find the attachment.
Thank you for your valuable answer but I used following code and it is working.
T = T./86400;
dt = datetime(T+1904*365.24264707,'ConvertFrom','datenum')
I will also try your code
Thank you again

Iniciar sesión para comentar.

Categorías

Más información sobre Time Series Events en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by