UTCOFFSET

Returns the UTC Time Offset for a specific longitude.

Syntax

UTCOFFSET(longitude, is_daylight_saving)

longitude longitude is the string or numeric expression to be considered
is_daylight_saving Optional. Boolean value, either TRUE or FALSE. Decides whether the current location to be considered is in daylight savings time. Default is FALSE if omitted.

Remark

If is_day_saving is TRUE, which means the location to be considered is in daylight savings time, 1 will be added to the normal UTC Time Offset.


See Also:

SUNRISE
SUNSET
SUNTIMES