MATLAB Answers

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

2 views (last 30 days)
Kelly Kyriakou
Kelly Kyriakou on 23 Sep 2016
Commented: George on 23 Sep 2016
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 Comment
Peter Perkins
Peter Perkins on 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.

Sign in to comment.

Answers (1)

George on 23 Sep 2016
A = table(datetime());
writetable(A, 'myfile.xlsx');

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!