MATLAB Answers

convert excel dateserial number to matlab serial number

5 views (last 30 days)
AA
AA on 17 Mar 2017
Commented: Star Strider on 18 Mar 2017
hi guys, i have an excel file that displays the following dateserial number 19300101. this includes the date as well as time. how can i convert it within matlab to a matlab dateserial number?

Answers (1)

Star Strider
Star Strider on 17 Mar 2017
If you have R2014b or later, you have the datetime functions.
X = 19300101
t = datetime(X,'ConvertFrom','excel')
X =
19300101
t =
datetime
17-Nov-54741 00:00:00
I suspect that ‘X’ is not an Excel serial date but a date vector of some other format.

  2 Comments

Star Strider
Star Strider on 18 Mar 2017
AA’s ‘Answer’ moved here
no the format is yyyyMMdd HHmmss
Star Strider
Star Strider on 18 Mar 2017
You have to supply the hour, minute, and second values as well. If they are strings, use them directly in datenum. If they are numbers, you must first convert them to strings (easiest with the sprintf function):
dn = datenum(sprintf('%08d %06d', [19300101 000000]), 'yyyyMMdd HHmmss')
dn =
704888.000694444
You must supply the date and time (strings or vectors) to match your format string.
You can do the same sort of conversion with datetime objects. I used datenum here because everyone has it.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by