convert excel dateserial number to matlab serial number

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?

[per isakson]

Jan-1-1930 ?

Answer 1

[Star Strider]

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.

[Star Strider]

AA’s ‘Answer’ moved here —

no the format is yyyyMMdd HHmmss

[Star Strider]

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.