Offsets and DST
TZ_OFFSET_HOURS
Returns a DST-aware UTC offset as decimal hours.
Syntax
=TZ_OFFSET_HOURS(zone, [datetime])Parameters
NameTypeDescription
Name
zoneTypetext
DescriptionIANA time zone to evaluate.
Name
datetime?Typetext, number, or date
DescriptionInstant to evaluate. Defaults to now.
Returns
The offset in hours. Fractional offsets are supported.
Example
=TZ_OFFSET_HOURS("Asia/Kolkata")Result: 5.5