Skip to main content
Version: 2.3

MSTOSERIAL

Converts the given elapsed milliseconds, since UNIX epoch time, to a serial date value.

Syntax

=MSTOSERIAL(TimeValue)

Arguments

NameDescription
TimeValueMilliseconds since UNIX epoch time (1st of January 1970).

Return Value

Date value deducted from milliseconds.

Example

FunctionResultComment
=MSTOSERIAL(3230234343334)37386.97157The given date value represents the 10th of May, 2002, 23:19.