MATLAB Answers

issues writing a time string to excel

1 view (last 30 days)
A
A on 12 Jan 2016
Answered: Adithya Addanki on 14 Jan 2016
I am trying to write the following string (generated using datestr) into excel: '12:01:33.500 AM'
In excel, it truncates the hour (somehow it gets auto-formatted to mm:ss. If I manually change the format to general, it shows some meaningless number 0.00108217592592593). I only have this issue with '12' as the hour- for example, '1:00:37.750 AM' exports fine (cell is formatted as general).
any idea what's going on?

  0 Comments

Sign in to comment.

Answers (1)

Adithya Addanki
Adithya Addanki on 14 Jan 2016
Hi,
I noticed the same on my machine, but it displayed the time in required format when I changed the format of the cell to "Time".
Please format the cell as "Time". You may also select "Custom" and pick a format that you would prefer to see.
Thank you,
Adithya

  0 Comments

Sign in to comment.