Offsets and DST
TZ_DIFF
Calculates the hour difference between two zones at an instant.
Syntax
=TZ_DIFF(fromZone, toZone, [datetime])Parameters
NameTypeDescription
Name
fromZoneTypetext
DescriptionFirst IANA time zone.
Name
toZoneTypetext
DescriptionSecond IANA time zone.
Name
datetime?Typetext, number, or date
DescriptionInstant interpreted in fromZone. Defaults to the current instant.
Returns
toZone offset minus fromZone offset, in hours.
Example
=TZ_DIFF("America/Los_Angeles", "Europe/London", "2026-06-01")Result: 8