Today, I am writing about the default available time zones and regions (Locale) for SharePoint Online.
As we know globally, we have multiple time zones and standard timings as well. For each time zone, we have an option in Office 365 or any other SharePoint Application to change the time zone, region, locale, time format etc.
It’s quite difficult to remember all those time zones, so I have copied all the time zones and region locales to an Excel sheet with valued ID.
Time ZoneIt specifies standard time zone. For example, for India we use IST but for globally, it is called as UTC (Universal Time Coordinated).
Time Zone For Office 365 | |
| Value | Description |
| <option value="39"> | (UTC-12:00) International Date Line West |
| <option value="95"> | (UTC-11:00) Coordinated Universal Time-11 |
| <option value="15"> | (UTC-10:00) Hawaii |
| <option value="14"> | (UTC-09:00) Alaska |
| <option value="78"> | (UTC-08:00) Baja California |
| <Default selected" value="13"> | (UTC-08:00) Pacific Time (US and Canada) |
| <option value="38"> | (UTC-07:00) Arizona |
| <option value="77"> | (UTC-07:00) Chihuahua, La Paz, Mazatlan |
| <option value="12"> | (UTC-07:00) Mountain Time (US and Canada) |
| <option value="55"> | (UTC-06:00) Central America |
| <option value="11"> | (UTC-06:00) Central Time (US and Canada) |
| <option value="37"> | (UTC-06:00) Guadalajara, Mexico City, Monterrey |
| <option value="36"> | (UTC-06:00) Saskatchewan |
| <option value="35"> | (UTC-05:00) Bogota, Lima, Quito |
| <option value="10"> | (UTC-05:00) Eastern Time (US and Canada) |
| <option value="34"> | (UTC-05:00) Indiana (East) |
| <option value="88"> | (UTC-04:30) Caracas |
| <option value="91"> | (UTC-04:00) Asuncion |
| <option value="9"> | UTC-04:00) Atlantic Time (Canada) |
| <option value="81"> | (UTC-04:00) Cuiaba |
| <option value="33"> | (UTC-04:00) Georgetown, La Paz, Manaus, San Juan |
| <option value="28"> | (UTC-03:30) Newfoundland |
| <option value="8"> | UTC-03:00) Brasilia |
| <option value="85"> | (UTC-03:00) Buenos Aires |
| <option value="32"> | (UTC-03:00) Cayenne, Fortaleza |
| <option value="60"> | (UTC-03:00) Greenland |
| <option value="90"> | (UTC-03:00) Montevideo |
| <option value="103" | (UTC-03:00) Salvador |
| <option value="65"> | (UTC-03:00) Santiago |
| <option value="96"> | (UTC-02:00) Coordinated Universal Time-02 |
| <option value="30"> | (UTC-02:00) Mid-Atlantic |
| <option value="29"> | (UTC-01:00) Azores |
| <option value="53"> | (UTC-01:00) Cabo Verde |
| <option value="86"> | (UTC) Casablanca |
| <option value="93"> | (UTC) Coordinated Universal Time |
| <option value="2"> | UTC) Dublin, Edinburgh, Lisbon, London |
| <option value="31"> | (UTC) Monrovia, Reykjavik |
| <option value="4"> | UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
| <option value="6"> | UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
| <option value="3"> | UTC+01:00) Brussels, Copenhagen, Madrid, Paris |
| <option value="57"> | (UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
| <option value="69"> | (UTC+01:00) West Central Africa |
| <option value="83"> | (UTC+01:00) Windhoek |
| <option value="79"> | (UTC+02:00) Amman |
| <option value="5"> | UTC+02:00) Athens, Bucharest |
| <option value="80"> | (UTC+02:00) Beirut |
| <option value="49"> | (UTC+02:00) Cairo |
| <option value="98"> | (UTC+02:00) Damascus |
| <option value="50"> | (UTC+02:00) Harare, Pretoria |
| <option value="59"> | (UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius |
| <option value="27"> | (UTC+02:00) Jerusalem |
| <option value="7"> | UTC+02:00) Minsk (old) |
| <option value="104"> | (UTC+02:00) E. Europe |
| <option value="100"> | (UTC+02:00) Kaliningrad (RTZ 1) |
| <option value="26"> | (UTC+03:00) Baghdad |
| <option value="101"> | (UTC+03:00) Istanbul |
| <option value="74"> | (UTC+03:00) Kuwait, Riyadh |
| <option value="109" | (UTC+03:00) Minsk |
| <option value="51"> | (UTC+03:00) Moscow, St. Petersburg, Volgograd (RTZ 2) |
| <option value="56"> | (UTC+03:00) Nairobi |
| <option value="25"> | (UTC+03:30) Tehran |
| <option value="24"> | (UTC+04:00) Abu Dhabi, Muscat |
| <option value="54"> | (UTC+04:00) Baku |
| <option value="106"> | (UTC+04:00) Izhevsk, Samara (RTZ 3) |
| <option value="89"> | (UTC+04:00) Port Louis |
| <option value="82"> | (UTC+04:00) Tbilisi |
| <option value="84"> | (UTC+04:00) Yerevan |
| <option value="48"> | (UTC+04:30) Kabul |
| <option value="58"> | (UTC+05:00) Ekaterinburg (RTZ 4) |
| <option value="87"> | (UTC+05:00) Islamabad, Karachi |
| <option value="47"> | (UTC+05:00) Tashkent |
| <option value="23"> | (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi |
| <option value="66"> | (UTC+05:30) Sri Jayawardenepura |
| <option value="62"> | (UTC+05:45) Kathmandu |
| <option value="71"> | (UTC+06:00) Astana |
| <option value="102"> | (UTC+06:00) Dhaka |
| <option value="46"> | (UTC+06:00) Novosibirsk (RTZ 5) |
| <option value="61"> | (UTC+06:30) Yangon (Rangoon) |
| <option value="22"> | (UTC+07:00) Bangkok, Hanoi, Jakarta |
| <option value="64"> | (UTC+07:00) Krasnoyarsk (RTZ 6) |
| <option value="45"> | (UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi |
| <option value="63"> | (UTC+08:00) Irkutsk (RTZ 7) |
| <option value="21"> | (UTC+08:00) Kuala Lumpur, Singapore |
| <option value="73"> | (UTC+08:00) Perth |
| <option value="75"> | (UTC+08:00) Taipei |
| <option value="94"> | (UTC+08:00) Ulaanbaatar |
| <option value="20"> | (UTC+09:00) Osaka, Sapporo, Tokyo |
| <option value="72"> | (UTC+09:00) Seoul |
| <option value="70"> | (UTC+09:00) Yakutsk (RTZ 8) |
| <option value="19"> | (UTC+09:30) Adelaide |
| <option value="44"> | (UTC+09:30) Darwin |
| <option value="18"> | (UTC+10:00) Brisbane |
| <option value="76"> | (UTC+10:00) Canberra, Melbourne, Sydney |
| <option value="43"> | (UTC+10:00) Guam, Port Moresby |
| <option value="42"> | (UTC+10:00) Hobart |
| <option value="99"> | (UTC+10:00) Magadan |
| <option value="68"> | (UTC+10:00) Vladivostok, Magadan (RTZ 9) |
| <option value="107"> | (UTC+11:00) Chokurdakh (RTZ 10) |
| <option value="41"> | (UTC+11:00) Solomon Is., New Caledonia |
| <option value="108" | (UTC+12:00) Anadyr, Petropavlovsk-Kamchatsky (RTZ 11) |
| <option value="17"> | (UTC+12:00) Auckland, Wellington |
| <option value="97"> | (UTC+12:00) Coordinated Universal Time+12 |
| <option value="40"> | (UTC+12:00) Fiji |
| <option value="92"> | (UTC+12:00) Petropavlovsk-Kamchatsky - Old |
| <option value="67"> | (UTC+13:00) Nuku'alofa |
| <option value="16"> | (UTC+13:00) Samoa |
Join the conversation! Your thoughts help the community grow.