TRUECALC
Functions

TZWORLDCLOCK

Friendly one-line summary comparing the time across N zones

Try it

When to use it

When should I use TZWORLDCLOCK instead of TZCONVERT or TZBOARD?

Use TZWORLDCLOCK when you need a single human-readable sentence — for an AI agent reply, a chat message, or a dashboard tooltip — that tells the reader what time it is across several zones at once. TZCONVERT returns raw date serials for further calculation; TZBOARD assembles a structured multi-row table; TZWORLDCLOCK produces finished prose you can drop directly into a message.

How does TZWORLDCLOCK handle zones like India that have a non-whole-hour offset?

TZWORLDCLOCK renders sub-hour deltas in hours-and-minutes form, for example '3:30 behind' for India Standard Time at UTC+5:30. This matches how people naturally describe half-hour and quarter-hour timezone gaps rather than expressing them as decimal fractions.

What happens if the anchor and one of the comparison zones are in the same UTC offset at that instant?

TZWORLDCLOCK shows that zone with a '0:00 difference' or equivalent phrasing, making it clear the clocks read the same time even if the zone names differ.

Use cases

Generate a one-line status for a global sales call anchored in New York

Produce a human-readable world-clock blurb for an on-call handoff

Used in

hr · operations · sales

Syntax

TZWORLDCLOCK(anchor,zones,[base])

On this page