Functions
TZPART
Local wall-clock field: year|month|day|hour|minute|second|weekday
Try it
When to use it
When should I use TZPART instead of YEAR(), MONTH(), or DAY()?
Use TZPART when your instant is stored as a zoned value (from TZDATETIME or TZCONVERT) and you need a field expressed in the local wall-clock time of that zone, not in UTC or the spreadsheet default timezone.
What values does TZPART return for the weekday unit?
TZPART returns an integer from 1 (Sunday) through 7 (Saturday), matching the same Sunday-origin convention as the WEEKDAY function.
What happens if I pass a unit string that is not recognized?
TZPART returns an error, so make sure unit is one of: year, month, day, hour, minute, second, or weekday.
Use cases
Get the local day-of-month for a shift scheduled in a remote timezone
Determine the local weekday of a cross-timezone meeting
Used in
operations · hr · engineering
Syntax
TZPART(zoned,unit)