Skip to main content
Version: Streamsheets 2.5

EXCEL2JSONTIME

Converts a serial date to an ISO 8601 date of following format: YYYY-MM-DDThh:mm:ss.sssZ A serial date is recognizes as a date by Streamsheets. You can get a serial date by using NOW().

Syntax

=EXCEL2JSONTIME(Number)

Arguments

NameDescription
NumberA serial number, which contains a complete date representation.

Return

An ISO 8601 date string.

Examples

FormulaResultComment
=EXCEL2JSONTIME(15453.767864710648)
2012-04-23T18:25:43.511ZThe given serial number represents the 23th of April, 2012, 18:24.