Skip to main content

JSON2EXCELTIME

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

Return Value

A serial number representing the specified date string.

Example

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