TZTABLE

Try it

When to use it

When should I use TZTABLE instead of TZBOARD?

Prefer TZBOARD in all new formulas. Use TZTABLE only when maintaining legacy sheets that already reference it — both functions return identical results, so there is no behavioral reason to choose TZTABLE over TZBOARD.

What happens if I mix TZTABLE and TZBOARD calls in the same workbook?

They return the same structured world-clock data, so mixing them is safe. For consistency, prefer one name throughout a workbook — TZBOARD is the canonical name.

Does TZTABLE accept the same arguments as TZBOARD?

Yes. TZTABLE is a direct alias of TZBOARD and accepts the same anchor datetime and one or more zone identifiers, producing identical output.

Use cases

Compare shift handoff times across global operations centers

Snapshot a UTC instant across regional offices

Used in

engineering · operations

Syntax

TZTABLE(anchor,zones,[base])