How convert date and time to number that excel will recognize the really date and time?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Peter Perkins
am 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.
Antworten (1)
George
am 23 Sep. 2016
A = table(datetime());
writetable(A, 'myfile.xlsx');
3 Kommentare
Walter Roberson
am 23 Sep. 2016
If the dates and times are in two cell arrays, then you can use
strjoin(dates_cell(:), {' '}, times_cell(:))
Siehe auch
Kategorien
Mehr zu Calendar finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!