CONVERTTZ
Description
Converts a datetime value from one time zone to another.
Syntax
CONVERTTZ(
range
,
from_time_zone_id
,
to_time_zone_id
)
- range: The cell, or range of cells, to return the converted time zone for.
- from_time_zone_id: The time zone specifier to convert from. Examples: GMT, US/Central.
- to_time_zone_id: The time zone specifier to convert to.
Example
Formula | Result |
|---|---|
=CONVERTTZ(A8,"America/Montreal","US/Pacific") where A8 contains 10/4/2016 5:37
PM | 10/4/2016 2:37 PM |
Notes
- Time zone IDs are based on the Java TimeZone utility. A complete list of time zones is available at http://joda-time.sourceforge.net/timezones.html. Examples:
- America/New_York
- Asia/Hong_Kong
- Australia/Melbourne
- Canada/Eastern
- Europe/London
- GMT
- MET
- US/Mountain
- UTC