Timezone Toolkit

Zones, Lookup, and Scheduling

TZ_MEETING

Shows one meeting time across many target zones.

Syntax

=TZ_MEETING(datetime, fromZone, zones, [format])

Parameters

Namedatetime
Typetext, number, or date
DescriptionThe meeting time interpreted in fromZone.
NamefromZone
Typetext
DescriptionIANA zone where datetime is written.
Namezones
Typetext or range
DescriptionTarget zones as a range or comma/semicolon list.
Nameformat?
Typetext
DescriptionOptional format for the Local Time column.

Returns

Rows of Time Zone, Local Time, UTC Offset, and Abbrev.

Example

=TZ_MEETING("2026-06-01 09:00", "America/New_York", "Europe/London,Asia/Tokyo")

Result: Europe/London -> 2026-06-01 14:00:00; Asia/Tokyo -> 22:00:00

    xs