# How to Convert Time Zones in Excel (3 Ways)

## 3 Ways to Convert Time Zones in Excel

Here is a dataset of individual times in London city and the adjustment of other cities. We will calculate the times in each city.

### Method 1 – Using the MOD Function to Convert Time Zones

Steps:

• Select F5 and insert the following formula:
=MOD(C5+(E5/24),1)

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.

• Hit Enter.

• Drag down the Fill Handle tool to fill the other cells with the corresponding formula.

• Your results will look like the screenshot below.

### Method 2 – Converting Current Time to GMT

Steps:

• Move to cell D5 and put NOW(). It will be the current time as input.
• Add the adjustment time compared to GMT and divide it by 24. 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.

• Repeat for other time zones with their corresponding time difference and your result will be ready.

### Method 3 – Converting GMT Time to Another Time Zone

Steps:

• Select cell D5 and insert =NOW().
• Subtract the time difference from the NOW. The time difference will be divided by 24 hours.

• 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 to test these methods.

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

Advanced Excel Exercises with Solutions PDF