Skip to main content
Version: Streamsheets 2.5

SERIALTOMS

Converts the given serial number to the elapsed milliseconds since 1st of January 1900. A serial date is recognized as a date by Streamsheets. You can get a serial date by using NOW().

Syntax

=SERIALTOMS(Date, UTC)

Arguments

NameTypeDescription
DateNumberA serial number consists out of two numbers. The number to the left of the decimal defines the days since 01.01.1900. The number to the right of the decimal defines the fraction of the day.
UTCBooleanBoolean to specify if conversion should respect locale timezone, i.e. local timezone offset is subtracted. Defaults to FALSE.

Return

Elapsed milliseconds as a number deducted from the DateValue.

Examples

FormulaResultComment
=SERIALTOMS(37386.97157)
1021072743648The given date value represents the 10th of May, 2002, 23:19.
=SERIALTOMS(37386.97157, TRUE)
1021065543648Same as before but respects local german timezone leading to 10th of May, 2002, 21:19.
=SERIALTOMS(NOW(), TRUE)
1628585618164Current time in UTC as for local german time 10.08.2021, 10:53.