JSONTIME2EXCELΒΆ

Converts an ISO 8601 date string to a serial number.

Syntax

=JSONTIME2EXCEL(text)

Arguments

Name

Description

text

An ISO 8601 date string of following format: YYYY-MM-DDThh:mm:ss.sssZ

Return Value

A serial number representing the specified date string.

Example

Function

Result

Comment

=JSONTIME2EXCEL(2012-04-23T18:25:43.511Z)

15453.767864710648

The given ISO date as serial number.