Functions
TZCOMPARETEXT
Alias of TZWORLDCLOCK
Try it
When to use it
When should I use TZCOMPARETEXT instead of TZWORLDCLOCK?
You should not prefer TZCOMPARETEXT in new formulas. It exists only for backward compatibility — use TZWORLDCLOCK instead, as both return the same friendly natural-language summary.
What does TZCOMPARETEXT return when given multiple time zones?
It returns the same friendly natural-language summary as TZWORLDCLOCK, describing the current time across the provided zones relative to the anchor.
Can I mix TZCOMPARETEXT with other timezone functions in the same workbook?
Yes, TZCOMPARETEXT is fully interchangeable with TZWORLDCLOCK, so you can use both in the same workbook without conflict — though migrating to TZWORLDCLOCK is recommended.
Use cases
Compare morning standup time across two regions
Summarize shift overlap between headquarters and remote teams
Used in
hr · operations
Syntax
TZCOMPARETEXT(anchor,zones,[base])