MSTOSERIALΒΆ

Converts the given elapsed milliseconds to a date value.

Syntax

=MSTOSERIAL(TimeValue)

Arguments

Name

Description

TimeValue

Milliseconds to convert to timevalue.

Return Value

Date value deducted from milliseconds.

Example

Function

Result

Comment

=MSTOSERIAL(3230234343334)

37386.97157

The given date value represents the 10th of May, 2002, 23:19.