Timezone Toolkit

Parse, Format, and Epochs

TZ_PARSE

Parses date/time text into a normalized ISO string with offset.

Syntax

=TZ_PARSE(text, zone, [inputFormat])

Parameters

Nametext
Typetext or range
DescriptionThe date/time text to parse.
Namezone
Typetext
DescriptionZone used when the text does not include its own offset or zone.
NameinputFormat?
Typetext
DescriptionOptional Luxon parse pattern for non-standard text, such as "dd/MM/yyyy".

Returns

An ISO 8601 string carrying the zone offset.

Example

=TZ_PARSE("01/06/2026 09:00", "Europe/London", "dd/MM/yyyy HH:mm")

Result: 2026-06-01T09:00:00+01:00

    xs