How to get current time zone and display in cell in Excel?
Do you know how to find out what time zone a system is set to in your computer? Here I will show you an easy way to get it down in Excel.
The following user-defined function will help you to display the current time zone of system directly in needed cells in Excel. Please do as follows.
1. Press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, click Insert > Module. Then copy below VBA code into the Module window.
VBA code: Get current time zone in Excel
Function GetTimeZoneAtPresent() As String 'Updated by Extendoffice 20180814 Dim xObjIs, xObjI On Error GoTo ER Set xObjIs = GetObject("winmgmts:\\.\root\cimv2").ExecQuery("Select * From Win32_TimeZone") If xObjIs.Count = 1 Then For Each xObjI In xObjIs If Len(xObjI.Caption) > 1 Then GetTimeZoneAtPresent = xObjI.Caption Exit Function Else GetTimeZoneAtPresent = "Null" Exit Function End If Next End If ER: GetTimeZoneAtPresent = "Failed" End Function
3. Press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.
4. Select a cell you need to display the time zone, type this formula: =GetTimeZoneAtPresent() and press the Enter key to get the time zone detail. See screenshot:
Best Office Productivity Tools
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!