pvl_exceltime2matlab

Convert a Microsoft Excel time to a MATLAB datenum

Contents

Syntax

MatTime = pvl_exceltime2matlab(ExcTime)

Description

Converts a Microsoft Excel serial time to a MATLAB datenum. Specifically, it converts from Excel's "1900" date system (days from Jan-1-1900 00:00:00)to MATLAB's datenum date system (days from Jan-1-0000 00:00:00).

Inputs

Outputs

Example

Example uses Jan 1, 1987 13:00

ExcTime = 31778.541666667;
MatTime = pvl_exceltime2matlab(ExcTime)
datestr(MatTime)
MatTime =

   7.2574e+05


ans =

01-Jan-1987 13:00:00

See Also

pvl_matlabtime2excel

Copyright 2014 Sandia National Laboratories