And to convert GMT/UTC to local time, the Add hours to date of Formulas can do you a favor.Īfter free installing Kutools for Excel, please do as below:ġ. There is a handy tool – Formula Helper in Kutools for Excel, which includes multiple useful and powerful functions can help you do some complex calculation. For converting the decimal number to time, please select the decimal number, and click Home > Number Format > Time. (2) The formula =A2 + (9 / 24) will return a decimal number. (1) In above formulas, 9 is the number of hours the local time ahead to GMT, and you can change it as you need, if the local time is backward to the GMT, you just can change the plus sign + to minus sign. Select a blank cell and enter one formula of below, and press Enter to get the local time. 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：ġ.
Utc time to mountain time how to#
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?
0 kommentar(er)
