Skip to main content
Version: Streamsheets 2.5

MSTOSERIAL

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

Syntax

=MSTOSERIAL(TimeValue, UTC)

Arguments

NameTypeDescription
TimeValueNumberMilliseconds since UNIX epoch time (1st of January 1970).
UTCBooleanSpecifies, if conversion should respect locale timezone, i.e. local timezone offset is added. Defaults to FALSE.

Return

Date value deducted from milliseconds.

Examples

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