How convert date and time to number that excel will recognize the really date and time?

1 visualización (últimos 30 días)
I need to convert a column that contains dates to numbers and a column that contains time to number also in order to be able to perform some processes. I tried x2mdate and datenum but when I open the file with excel and I convert it again to date and time respectively the excel doesn't recognize the real dates and times. What is my wrong?
Thank you in advance
  1 comentario
Peter Perkins
Peter Perkins el 23 de Sept. de 2016
Kelly, I don't think you've provided enough information to answer your question. What exactly are your dates and times stored as, you writing to a file or working within MATLAB, and so on.

Iniciar sesión para comentar.

Respuestas (1)

George
George el 23 de Sept. de 2016
A = table(datetime());
writetable(A, 'myfile.xlsx');
  3 comentarios
Walter Roberson
Walter Roberson el 23 de Sept. de 2016
If the dates and times are in two cell arrays, then you can use
strjoin(dates_cell(:), {' '}, times_cell(:))
George
George el 23 de Sept. de 2016
In addition to Walter's comment you can look at the datetime format properties.

Iniciar sesión para comentar.

Categorías

Más información sobre Calendar 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