Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.


Math Forum » Discussions » Software » comp.soft-sys.matlab

Topic: time format changed in excel
Replies: 3   Last Post: Sep 19, 2013 6:02 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
ryanshuell@gmail.com

Posts: 128
Registered: 2/11/08
Re: time format changed in excel
Posted: Sep 19, 2013 1:01 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

What about the datestr function?
http://www.mathworks.com/help/matlab/ref/datestr.html
xtimestr = datestr(xtime,'HH:MM');

TideMan <mulgor@gmail.com> wrote in message <d1a92c8f-bd71-4145-b290-97fbd6fc26b1@googlegroups.com>...
> On Wednesday, August 21, 2013 5:44:12 AM UTC+12, Diane wrote:
> > Hello, I am trying to write time of the format HH:MM:SS.FFF (without AM or PM) to an excel file. In matlab the time appears correctly (00:00:00.000), however, when it is saved to the excel file, AM is added (00:00:00.000 AM). Any suggestions? (I am working with numerous files and wish to avoid having to do any formatting within excel.)
>
> It's Excel trying to be clever.
> Unfortunately, you have no alternative to formatting in Excel.




Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.