# 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.

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

Here,

C5= Time you want to convert.

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. ### 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. • 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. • Finally, your GMT time will be converted to your current time zone. ## Practice Section

We have provided a Practice Section on each sheet on the right side for your practice. Please do it by yourself. ## Related Articles 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 Advanced Excel Exercises with Solutions PDF  