To get the current GMT, you can take reference from this Ģ. Select a blank cell and enter the current GMT time into it, here take A2 for instances. Supposing there is a city-Tokyo whose local time is ahead 9 hours to GMT time, and you can convert the GMT time to its local time by following these steps：ġ.
Here this tutorial can tell you how to calculate the local time based on the UTC/GMT time in Excel.Ĭonvert UTC/GMT time to local time with formulasĬonvert UTC/GMT time to local time with Kutools for Excel And to get the different local times, you need to use UTC/GMT time. If you are working in an international company, you may need to know and deal with different local times of multiple zones. How to quickly convert UTC/GMT time to local time?
