Skip to main content
Version: Streamsheets 2.4

JSONTIME2EXCEL

Converts an ISO 8601 date string to a serial number.

Syntax

=JSONTIME2EXCEL(text)

Arguments

NameDescription
textAn 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 Value

A serial number representing the specified date string.

Example

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