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 |
|---|---|---|
| 37386.97157 | The given value represents the 10th of May, 2002, 23:19. |
| 37386.97157 | Same result as before but converts from UTC milliseconds to local german time. |