Timezone Toolkit

Zones, Lookup, and Scheduling

TZ_LOOKUP

Finds time zones by city, country, or abbreviation.

Syntax

=TZ_LOOKUP(query)

Parameters

Namequery
Typetext
DescriptionCity, country, or abbreviation, such as "Tokyo" or "PST".

Returns

Rows of time zone, city, country, current UTC offset, and abbreviation.

Example

=TZ_LOOKUP("Tokyo")

Result: Asia/Tokyo | Tokyo | Japan | +09:00 | GMT+9

    xs