Trial software

Problem plotting date from excel file

1 view (last 30 days)

Show older comments

Aubrey on 28 Jul 2014

0
Link

Direct link to this question

https://www.mathworks.com/matlabcentral/answers/143582-problem-plotting-date-from-excel-file

Answered: Matz Johansson Bergström on 28 Jul 2014

Hi, I am having trouble plotting date (as my x axis) from an excel file. My date format is as follow: '6/16/2014 04:00:00 PM' I need to plot my data over time. Can anyone please tell me what function i must use to convert that date in to an acceptable format?

Thanks

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Answers (1)

Matz Johansson Bergström on 28 Jul 2014

0
Link

Direct link to this answer

https://www.mathworks.com/matlabcentral/answers/143582-problem-plotting-date-from-excel-file#answer_146618

I think you want Datenum.

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Categories

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Trial software