MATLAB: Where can I find the exceltime.m function

exceltime

I cannot find the exceltime.m function in my installation. I am using R2104B.

Thanks,

J.P.

Best Answer

Hi,

exceltime.m should be part of R2014b, no additional toolboxes are required. Are you sure you are using it in the right way? Such as:

e = exceltime(t)

e = exceltime(t,dateType)

where 't' being your datetime array?

Have a look here if you need additional help.

Related Solutions

MATLAB: Can i take correct date from this data

You need to be precise with the format string.

Try

datetime(t,'InputFormat','MMM yyyy')

MATLAB: Create a numeric variable DATE+HOUR

There's rarely a good reason to use datenum rather than datetime values. See Why are datetime arrays better than datenum?

% Convert to datetime
Time = '01:15:02 12/09/19';
datetime(Time,'InputFormat','HH:mm:ss MM/dd/yy')
ans = datetime
   09-Dec-2019 01:15:02

Date numbers in Excel represent the number of days since Jan 1 1900 whereas date numbers in Matlab represent the number of days since Jan 1,0000 so there's a 693960 day difference (see documentation).

If you have the Financial Toolbox you could use x2mdate / m2xdate or you could convert it on your own using the offset mentioned in the documentation.

Best Answer

Related Solutions

MATLAB: Can i take correct date from this data

MATLAB: Create a numeric variable DATE+HOUR

Related Question