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.

Get current time zone and display in cell with User-defined function

Get current time zone and display in cell with User-defined function

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: