How convert date and time to number that excel will recognize the really date and time?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Peter Perkins
le 23 Sep 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.
Réponses (1)
George
le 23 Sep 2016
A = table(datetime());
writetable(A, 'myfile.xlsx');
3 commentaires
Walter Roberson
le 23 Sep 2016
If the dates and times are in two cell arrays, then you can use
strjoin(dates_cell(:), {' '}, times_cell(:))
Voir également
Catégories
En savoir plus sur Calendar dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!