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.
- 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.
- Now, drag down the Fill Handle tool for other cells with the corresponding 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.
- 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.
- 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.
- 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.
- Finally, your GMT time will be converted to your current time zone.
Read More: How to Convert GMT to EST in Excel (4 Quick Ways)
We have provided a Practice Section on each sheet on the right side for your practice. Please do it by yourself.
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.