Components and Math
TZ_BETWEEN
Measures elapsed time between two zoned date/times.
Syntax
=TZ_BETWEEN(datetime1, zone1, datetime2, zone2, unit)Parameters
NameTypeDescription
Name
datetime1Typetext, number, or date
DescriptionFirst date/time, interpreted in zone1.
Name
zone1Typetext
DescriptionIANA zone for datetime1.
Name
datetime2Typetext, number, or date
DescriptionSecond date/time, interpreted in zone2.
Name
zone2Typetext
DescriptionIANA zone for datetime2.
Name
unitTypetext
Descriptionyears, months, weeks, days, hours, minutes, or seconds.
Returns
datetime2 minus datetime1 in the selected unit.
Example
=TZ_BETWEEN("2026-06-01 09:00", "America/New_York", "2026-06-01 17:00", "Europe/London", "hours")Result: 3