How to Convert Time Zones in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset

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.
=MOD(C5+(E5/24),1)

Here,

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.

Read More: Convert Time Zone with Daylight Savings in Excel (2 Cases)


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.

Read More: How to Convert GMT to IST in Excel (2 Suitable Ways)


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 (4 Quick Ways)


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


Conclusion

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.


Related Articles

Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo