How to Convert Time Zones in Excel (3 Ways)

Time zones are especially important to know the actual time of separate places with respect to your current location. Whenever a person travels across the world, he/she wants to adjust the times in that time zone. If you have Microsoft Excel on your computer, the conversion process will be straightforward. Here we covered some formulas to convert time zones in Excel.

Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.

3 Ways to Convert Time Zones in Excel

Here is a dataset of individual times in London city and the adjustment of other cities. Now we will convert the times with that adjustment for those cities.


Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.

1. Using MOD Function to Convert Time Zones

To convert time zones, we use the MOD function. The MOD function mainly returns the remainder after a number is divided by the divisor. It took the result to sign the same as the sign of the divisor. For converting time zones with MOD function, you have to follow the following steps.

📌 Steps:

  • Initially, select F5 and write down the formula stated below.


C5= Time you want to convert.

E5= The adjustment time.

The syntax MOD(C5+(E5/24),1) divides the cell E5 number by 24 and returns the remainder, then it adds the remainder with cell C5 and shows the result.

  • After that, press ENTER.

Convert Time Zones with Formula

  • Now, drag down the Fill Handle tool for other cells with the corresponding formula.

Convert Time Zones with Formula

  • Finally, your results will look like the screenshot below.

2. Converting Current Time to GMT

GMT (Greenwich Mean Time) is the standard of International civil time. You can convert your current time to GMT by using the NOW function. The NOW function is a dynamic function that is used to show the timestamps. Follow these simple steps to convert time zones into Excel.

📌 Steps:

  • At first, move to cell D5 and put the NOW It will be the current time as input.
  • Secondly, you have to add the adjustment time compared to GMT and divide it by 24. For example, the time difference between the central zone and GMT time is 6 hours. So, you need to divide the time difference by 24 and add it with the NOW.

Converting Current Time to GMT

  • Finally, do it for other time zones with their corresponding time difference and your result will be ready.

3. Converting GMT Time to Another Time Zone

Sometimes, you may need to convert GMT time to another time zone. Do you think that is so tough? Nope. It’s quite a simple task. Let’s follow the steps below.

📌 Steps:

  • At first, select cell D5 and insert the NOW
  • After that, subtract the time difference from the NOW. The time difference will be divided by 24 hours.

Converting GMT Time to Another Time Zone

  • Finally, your GMT time will be converted to your current time zone.

Converting GMT Time to Another Time Zone

Read More: How to Convert GMT to EST in Excel

Practice Section

We have provided a Practice Section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


That’s all about today’s session. And these are some easy methods on how to convert time zones in Excel. Please let us know in the comments section if you have any questions or suggestions. For your better understanding, please download the practice sheet. Visit our website Exceldemy, a one-stop Excel solution provider, to find out diverse kinds of Excel methods. Thanks for your patience in reading this article.

Time Zone in Excel: Knowledge Hub

<< Go Back to Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF