Excel Formulas to Convert Date-time to Time Zone ~ Quick Tricks!!
Tags: excelformula, excelformulas
Published: 2021-05-07 04:22:51

---
title: Excel Formulas to Convert Date-time to Time Zone ~ Quick Tricks!!
published: true
date: 2021-05-06 07:37:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-convert-date-time-to-time-zone/
---

Supposing you are working in a foreign company, and you receive lots of reports with different date-times from different time zone every day. In this case, how can you **convert that date-time from senders time zones to your current time zone?**   Today I introduce you to some formulas to solve this problem. Let’s get them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

![Convert one time to another time zone](https://geekexcel.com/wp-content/uploads/2021/05/Convert-one-time-to-another-time-zone.png)<figcaption id="caption-attachment-36352">Convert one time to another time zone</figcaption>

## General Formula:

- You can use the below formula to convert a time from one time zone to another.

**=[MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(time+(hours/24),1)**

## Syntax Explanations:

- **MOD** – In Excel, the **[MOD function](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)** helps to return the remainder of the two numbers after division.
- **Time** – It specifies the input time.
- **Hours** – This value specifies the input time.
- **Division (/)** – It is used for dividing values or numbers.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input times in **Column B**.
- Now we are going to change them from one time zone to another based on the time adjustment in **Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-9.png)<figcaption id="caption-attachment-36354">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the result](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-result.png)<figcaption id="caption-attachment-36353">Enter the result</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-14.png)<figcaption id="caption-attachment-36355">Result</figcaption>

## Wrap-Up:

From this short tutorial, you can get to know how to **convert that date-time from senders time zones to your current time zone in Excel**. If you have any other **ideas** or **question** , do share with us here in the **comments** section below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Convert Excel Time into Unix Time ~ Quick Solution!!](https://geekexcel.com/excel-formulas-to-convert-excel-time-into-unix-time/)**
- **[Excel Formulas to Calculate the Number of Hours between Two Times!!](https://geekexcel.com/excel-formulas-to-calculate-the-number-of-hours-between-two-times/)**
- **[How to Find the Approximate Match with VLOOKUP in Excel?](https://geekexcel.com/how-to-find-the-approximate-match-with-vlookup-in-excel/)**