Skip to main content
Version: Streamsheets 2.5

JSONTIME2EXCEL

Converts an ISO 8601 date string to a serial number. A serial number is recognized as a date by Streamsheets. You can get a serial number by using NOW().

Syntax

=JSONTIME2EXCEL(text)

Arguments

NameTypeDescription
textStringAn ISO 8601 date string of following format: YYYY-MM-DDThh:mm:ss.sssZ. Note: minutes, seconds and milliseconds are optional and single digits are allowed.

Return

A serial number representing the specified date string.

Examples

FormulaResultComment
=JSONTIME2EXCEL(2012-04-23T18:25:43.511Z)
15453.767864710648The given ISO date as serial date.