MSTOSERIAL

Converts the given elapsed milliseconds, since UNIX epoch time, to a serial number. A serial number is recognized as a date by Eclipse Streamsheets.

Syntax

=MSTOSERIAL(TimeValue, UTC)

Arguments

Name	Type	Description
TimeValue	Number	Milliseconds since UNIX epoch time (1st of January 1970).
UTC	Boolean	Specifies, if conversion should respect locale timezone, i.e. local timezone offset is added. Defaults to FALSE.

Return

Date value deducted from milliseconds.

Examples

Formula	Result	Comment
=MSTOSERIAL(1021072743648)	37386.97157	The given value represents the 10th of May, 2002, 23:19.
=MSTOSERIAL(1021065543648, TRUE)	37386.97157	Same result as before but converts from UTC milliseconds to local german time.