The Math Forum

Search All of the Math Forum:

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

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

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

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 ]

Posts: 150
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?
xtimestr = datestr(xtime,'HH:MM');

TideMan <> wrote in message <>...
> 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]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.