NOWTZ
Description
Returns the current date and time based on the time zone you specify. NOWTZ()
generates a new date and time whenever any cell on the sheet changes. This function
is volatile; it generates a new value any time any cell in the workbook changes.
Syntax
NOWTZ([
time_zone_id
])
- time_zone_id: The time zone specifier, such as GMT, US/Central, and so on.
Example
Formula | Result |
|---|---|
=NOWTZ("US/Pacific") | 10/4/2016 5:37 PM |
Notes
- The function doesn't run as a volatile function if the Worksheets calculation mode is set toManualin .
- 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