exceltime

Syntax

Description

e = exceltime(t)
returns a double array containing Excel® serial date numbers equivalent to the datetime values in
t. Excel serial date numbers are the number of days and fractional days since
0-January-1900 00:00:00, and do not take into account time zone and leap
seconds.

e = exceltime(t,dateType)
returns the type of Excel serial date numbers specified by dateType. For
example, you can convert datetime values to the number of days since 1-January-1904
00:00:00.

Output Arguments

Excel serial date numbers, returned as a scalar, vector, matrix, or
multidimensional array of type double. Excel serial date numbers are not defined prior to their epoch
(0-January-1900 or 1-January-1904). Excel serial date numbers treat 1900 as a leap year. Therefore,
dates after February 28, 1900 are offset by one day relative to MATLAB® serial date numbers, and there is a discontinuity of one day
between February 28, 1900 and March 1, 1900.

Extended Capabilities

Tall ArraysCalculate with arrays that have more rows than fit in memory.

This function fully supports tall arrays. For
more information, see Tall Arrays.

Distributed ArraysPartition large arrays across the combined memory of your cluster using Parallel Computing Toolbox™.

This website uses cookies to improve your user experience, personalize content and ads, and analyze website traffic. By continuing to use this website, you consent to our use of cookies. Please see our Privacy Policy to learn more about cookies and how to change your settings.