TZBOARD
Technical world-clock board: one row per zone {zone,local,offset,delta,rollover,abbrev,dst}
Try it
When to use it
When should I use TZBOARD instead of TZWORLDCLOCK?
Use TZBOARD when you need structured data — one record per zone with fields like offset, delta, abbreviation, and DST flag — so you can render your own table, feed a dashboard component, or pass the result to downstream code. Use TZWORLDCLOCK when you only need a human-readable sentence summarizing the same zones.
What does the delta field in TZBOARD output represent?
Delta is the signed hour difference between each listed zone and the anchor zone. It lets you quickly see how far ahead or behind each zone is relative to your reference point, which is useful for scheduling meetings or computing deadlines across offices.
What happens if I pass a zone identifier that TZBOARD does not recognize?
TZBOARD returns #VALUE! for unrecognized zone identifiers. Use TZVALID to check a zone string before passing it to TZBOARD if your zone names come from user input or external data.
Use cases
Generate a financial-markets status board anchored to London open
Produce an on-call handoff board anchored to UTC midnight
Used in
engineering · operations · finance
Syntax
TZBOARD(anchor,zones,[base])