Version: Streamsheets 3.0

SERIAL.TO.MS

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

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

Arguments

Name	Type	Description
Date	Number	A 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.
UTC (optional)	Boolean	Boolean to specify if conversion should respect locale timezone, i.e. local timezone offset is subtracted. Default value: FALSE

Return

Type	Description
Number	Elapsed milliseconds as a number deducted from the DateValue.

Examples

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