MS.TO.SERIAL

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

Syntax

=MS.TO.SERIAL(TimeValue, [UTC])

Arguments

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

Return

Type	Description
Number	Date value deducted from milliseconds.

Examples

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