Spreadsheet: 880087d1727721785-dd-mm-yyyy-hh-mm-assistance-in-converting-via-formula-time-zone-conversion-testing
Sheet: Time Zone Mapping

Time Zone Abbreviation | Time Zone Name | UTC Offset | UTC Offset v2 | UTC Offset v3
BST | British Summer Time (British Standard Time from Mar 1968 to Oct 1971) | UTC+01 |  | 1
CET | Central European Time | UTC+01 |  | 1
DFT | AIX-specific equivalent of Central European Time[NB 1] | UTC+01 |  | 1
IST | Irish Standard Time[8] | UTC+01 |  | 1
MET | Middle European Time (same zone as CET) | UTC+01 |  | 1
WAT | West Africa Time | UTC+01 |  | 1
WEST | Western European Summer Time | UTC+01 |  | 1
CAT | Central Africa Time | UTC+02 |  | 2
CEST | Central European Summer Time | UTC+02 |  | 2
EET | Eastern European Time | UTC+02 |  | 2
HAEC | Heure Avancée d'Europe Centrale French-language name for CEST | UTC+02 |  | 2
IST | Israel Standard Time | UTC+02 |  | 2
KALT | [NAME] | UTC+02 |  | 2
MEST | Middle European Summer Time (same zone as CEST) | UTC+02 |  | 2
SAST | South African Standard Time | UTC+02 |  | 2
WAST | West Africa Summer Time | UTC+02 |  | 2
AST | Arabia Standard Time | UTC+03 |  | 3
EAT | East Africa Time | UTC+03 |  | 3
EEST | Eastern European Summer Time | UTC+03 |  | 3
FET | Further-eastern European Time | UTC+03 |  | 3
IDT | Israel Daylight Time | UTC+03 |  | 3
MSK | Moscow Time | UTC+03 |  | 3
SYOT | [NAME] | UTC+03 |  | 3
TRT | Turkey Time | UTC+03 |  | 3
VOLT | Volgograd Time | UTC+03 |  | 3
IRST | Iran Standard Time | UTC+03:30 |  | 3.5
AMT | Armenia Time | [NAME] |  | 4
AZT | Azerbaijan Time | [NAME] |  | 4
GET | Georgia Standard Time | [NAME] |  | 4
GST | Gulf Standard Time | [NAME] |  | 4
MUT | Mauritius Time | [NAME] |  | 4
RET | Réunion Time | [NAME] |  | 4
SAMT | [NAME] | [NAME] |  | 4
SCT | Seychelles Time | [NAME] |  | 4
AFT | Afghanistan Time | UTC+04:30 |  | 4.5
IRDT | Iran Daylight Time | UTC+04:30 |  | 4.5
AQTT | Aqtobe Time[5] | UTC+05 |  | 5
HMT | Heard and McDonald Islands Time | UTC+05 |  | 5
MAWT | [NAME] | UTC+05 |  | 5
MVT | [NAME] | UTC+05 |  | 5
ORAT | Oral Time | UTC+05 |  | 5
PKT | Pakistan Standard Time | UTC+05 |  | 5
TFT | French Southern and Antarctic Time[13] | UTC+05 |  | 5
TJT | Tajikistan Time | UTC+05 |  | 5
[NAME] | Turkmenistan Time | UTC+05 |  | 5
UZT | Uzbekistan Time | UTC+05 |  | 5
YEKT | Yekaterinburg Time | UTC+05 |  | 5
IST | Indian Standard Time | UTC+05:30 |  | 5.5 |  |  |  | 09:30:00 | 5
SLST | [NAME] | UTC+05:30 |  | 5.5 |  |  |  | 10:00:00 | 5
NPT | Nepal Time | UTC+05:45 |  | 5.5 |  |  |  | 09:30:00 | 5.5
ALMT | [NAME]] | UTC+06 |  | 6 |  |  |  | 10:00:00 | 5.5
BIOT | British Indian Ocean Time | UTC+06 |  | 6
BST | Bangladesh Standard Time | UTC+06 |  | 6
BTT | Bhutan Time | UTC+06 |  | 6
IOT | Indian Ocean Time | UTC+06 |  | 6
KGT | Kyrgyzstan Time | UTC+06 |  | 6
OMST | Omsk Time | UTC+06 |  | 6
VOST | Vostok Station Time | UTC+06 |  | 6
CCT | Cocos Islands Time | UTC+06:30 |  | 6.5
MMT | [NAME] | UTC+06:30 |  | 6.5
CXT | Christmas Island Time | UTC+07 |  | 7
DAVT | [NAME] | UTC+07 |  | 7
HOVT | [NAME] | UTC+07 |  | 7
ICT | Indochina Time | UTC+07 |  | 7
KRAT | Krasnoyarsk Time | UTC+07 |  | 7
NOVT | Novosibirsk Time [9] | UTC+07 |  | 7
THA | Thailand Standard Time | UTC+07 |  | 7
WIB | Western Indonesian Time | UTC+07 |  | 7
ACT | ASEAN Common Time (proposed) | UTC+08 |  | 8
AWST | Australian Western Standard Time | UTC+08 |  | 8
BNT | Brunei Time | UTC+08 |  | 8
CHOT | Choibalsan Standard Time | UTC+08 |  | 8
CST | China Standard Time | UTC+08 |  | 8
HKT | Hong Kong Time | UTC+08 |  | 8
HOVST | Hovd Summer Time (not used from 2017-present) | UTC+08 |  | 8
IRKT | Irkutsk Time | UTC+08 |  | 8
MST | Malaysia Standard Time | UTC+08 |  | 8
MYT | Malaysia Time | UTC+08 |  | 8
PHT | Philippine Time | UTC+08 |  | 8
PHST | Philippine Standard Time | UTC+08 |  | 8
SGT | Singapore Time | UTC+08 |  | 8
TST | Taiwan Standard Time | UTC+08 |  | 8
[NAME] | Ulaanbaatar Standard Time | UTC+08 |  | 8
WITA | Central Indonesia Time | UTC+08 |  | 8
WST | Western Standard Time | UTC+08 |  | 8
ACWST | Australian Central Western Standard Time (unofficial) | UTC+08:45 |  | 8.75
CWST | Central Western Standard Time (Australia) unofficial | UTC+08:45 |  | 8.75
CHOST | Choibalsan Summer Time | UTC+09 |  | 9
JST | Japan Standard Time | UTC+09 |  | 9
KST | Korea Standard Time | UTC+09 |  | 9
PWT | Palau Time[10] | UTC+09 |  | 9
TLT | Timor Leste Time | UTC+09 |  | 9
ULAST | Ulaanbaatar Summer Time | UTC+09 |  | 9
WIT | Eastern Indonesian Time | UTC+09 |  | 9
YAKT | Yakutsk Time | UTC+09 |  | 9
ACST | Australian Central Standard Time | UTC+09:30 |  | 9.5
AEST | Australian Eastern Standard Time | UTC+10 |  | 10
CHST | Chamorro Standard Time | UTC+10 |  | 10
CHUT | Chuuk Time | UTC+10 |  | 10
DDUT | Dumont d'Urville Time | UTC+10 |  | 10
PGT | Papua New Guinea Time | UTC+10 |  | 10
VLAT | [NAME] | UTC+10 |  | 10
[NAME] | Australian Central Daylight Saving Time | UTC+10:30 |  | 10.5
LHST | Lord Howe Standard Time | UTC+10:30 |  | 10.5
AEDT | Australian Eastern Daylight Saving Time | UTC+11 |  | 11
BST | [NAME] | UTC+11 |  | 11
KOST | Kosrae Time | UTC+11 |  | 11
LHST | Lord Howe Summer Time | UTC+11 |  | 11
MIST | Macquarie Island Station Time | UTC+11 |  | 11
NCT | New Caledonia Time | UTC+11 |  | 11
NFT | Norfolk Island Time | UTC+11 |  | 11
PONT | Pohnpei Standard Time | UTC+11 |  | 11
SAKT | Sakhalin Island Time | UTC+11 |  | 11
SBT | Solomon Islands Time | UTC+11 |  | 11
SRET | [NAME] | UTC+11 |  | 11
VUT | [NAME] | UTC+11 |  | 11
ANAT | Anadyr Time[4] | UTC+12 |  | 12
FJT | Fiji Time | UTC+12 |  | 12
[NAME] | Gilbert Island Time | UTC+12 |  | 12
MAGT | Magadan Time | UTC+12 |  | 12
MHT | Marshall Islands Time | UTC+12 |  | 12
NZST | New Zealand Standard Time | UTC+12 |  | 12
PETT | [NAME] | UTC+12 |  | 12
TVT | Tuvalu Time | UTC+12 |  | 12
WAKT | Wake Island Time | UTC+12 |  | 12
CHAST | Chatham Standard Time | UTC+12:45 |  | 12.75
NZDT | New Zealand Daylight Time | [NAME] |  | 13
PHOT | Phoenix Island Time | [NAME] |  | 13
TKT | [NAME] | [NAME] |  | 13
TOT | Tonga Time | [NAME] |  | 13
CHADT | Chatham Daylight Time | UTC+13:45 |  | 13.75
LINT | Line Islands Time | UTC+14 |  | 14
AZOST | Azores Summer Time | UTC±00 |  | 0
EGST | Eastern Greenland Summer Time | UTC±00 |  | 0
GMT | Greenwich Mean Time | UTC±00 |  | 0
UTC | Coordinated Universal Time | UTC±00 |  | 0
WET | Western European Time | UTC±00 |  | 0
AZOT | [NAME] | UTC-01 |  | -1
CVT | Cape Verde Time | UTC-01 |  | -1
EGT | Eastern Greenland Time | UTC-01 |  | -1
BRST | Brasília Summer Time | UTC-02 |  | -2
FNT | Fernando de Noronha Time | UTC-02 |  | -2
GST | South Georgia and the South Sandwich Islands Time | UTC-02 |  | -2
PMDT | [NAME] and Miquelon Daylight Time | UTC-02 |  | -2
UYST | Uruguay Summer Time | UTC-02 |  | -2
WGST | West Greenland Summer Time[14] | UTC-02 |  | -2
NDT | Newfoundland Daylight Time | UTC-02:30 |  | -2.5
ADT | Atlantic Daylight Time | UTC-03 |  | -3
AMST | Amazon Summer Time (Brazil)[2] | UTC-03 |  | -3
ART | Argentina Time | UTC-03 |  | -3
BRT | Brasília Time | UTC-03 |  | -3
CLST | Chile Summer Time | UTC-03 |  | -3
FKST | Falkland Islands Summer Time | UTC-03 |  | -3
GFT | French Guiana Time | UTC-03 |  | -3
PMST | [NAME] and Miquelon Standard Time | UTC-03 |  | -3
PYST | Paraguay Summer Time[11] | UTC-03 |  | -3
ROTT | Rothera Research Station Time | UTC-03 |  | -3
SRT | Suriname Time | UTC-03 |  | -3
UYT | Uruguay Standard Time | UTC-03 |  | -3
WGT | West Greenland Time[15] | UTC-03 |  | -3
NST | Newfoundland Standard Time | [NAME] |  | -3.5
NT | Newfoundland Time | [NAME] |  | -3.5
AMT | Amazon Time (Brazil)[3] | UTC-04 |  | -4
AST | Atlantic Standard Time | UTC-04 |  | -4
BOT | Bolivia Time | UTC-04 |  | -4
CDT | Cuba Daylight Time[7] | UTC-04 |  | -4
CLT | Chile Standard Time | UTC-04 |  | -4
COST | Colombia Summer Time | UTC-04 |  | -4
ECT | Eastern Caribbean Time (does not recognise DST) | UTC-04 |  | -4
EDT | Eastern Daylight Time (North America) | UTC-04 |  | -4
FKT | Falkland Islands Time | UTC-04 |  | -4
GYT | Guyana Time | UTC-04 |  | -4
PYT | Paraguay Time[12] | UTC-04 |  | -4
VET | Venezuelan Standard Time | UTC-04 |  | -4
ACT | Acre Time | UTC-05 |  | -5
CDT | Central Daylight Time (North America) | UTC-05 |  | -5
COT | Colombia Time | UTC-05 |  | -5
CST | Cuba Standard Time | UTC-05 |  | -5
EASST | Easter Island Summer Time | UTC-05 |  | -5
ECT | Ecuador Time | UTC-05 |  | -5
EST | Eastern Standard Time (North America) | UTC-05 |  | -5
PET | Peru Time | UTC-05 |  | -5
CST | Central Standard Time (Central America) | UTC-06 |  | -6
EAST | Easter Island Standard Time | UTC-06 |  | -6
GALT | [NAME] | UTC-06 |  | -6
MDT | Mountain Daylight Time (North America) | UTC-06 |  | -6
MST | Mountain Standard Time (North America) | UTC-07 |  | -7
PDT | Pacific Daylight Time (North America) | UTC-07 |  | -7
AKDT | Alaska Daylight Time | UTC-08 |  | -8
CIST | Clipperton Island Standard Time | UTC-08 |  | -8
PST | Pacific Standard Time (North America) | UTC-08 |  | -8
AKST | Alaska Standard Time | UTC-09 |  | -9
GAMT | Gambier Islands Time | UTC-09 |  | -9
[NAME] | Gambier Island Time | UTC-09 |  | -9
HDT | Hawaii–Aleutian Daylight Time | UTC-09 |  | -9
MART | Marquesas Islands Time | UTC-09:30 |  | -9.5
MIT | Marquesas Islands Time | UTC-09:30 |  | -9.5
CKT | Cook Island Time | UTC-10 |  | -10
HST | Hawaii–Aleutian Standard Time | UTC-10 |  | -10
SDT | Samoa Daylight Time | UTC-10 |  | -10
TAHT | Tahiti Time | UTC-10 |  | -10
NUT | [NAME] | UTC-11 |  | -11
SST | Samoa Standard Time | UTC-11 |  | -11
BIT | Baker Island Time | UTC-12 |  | -12
IDLW | International Date Line West time zone | UTC-12 |  | -12