exceltime
Convert datetime values to spreadsheet serial date numbers.
📝Syntax
e = exceltime(t)
📥Input Arguments
Parameter Description
inputs A datetime array.
📤Output Arguments
Parameter Description
output A double array of spreadsheet serial date values.
📄Description

Convert datetime values to spreadsheet serial date numbers.

exceltime uses the 1899-12-30 origin used by common spreadsheet serial-date calculations.

Array-valued inputs keep their data shape when the operation supports arrays. Scalar operands are expanded where the implementation defines scalar expansion.

💡Examples
Basic usage.
exceltime(datetime(1899, 12, 31))
exceltime(datetime(1900, 1, 1))
🔗See Also
datetimeduration
🕔Version History
Version Description
2.0.0 initial version
Edit this page on GitHub