You can use the following formulas to convert a time in Excel from one time zone to another:

**Method 1: Convert Time Zones by Subtracting Hours**

=A2 - TIME(4, 0, 0)

This particular formula will convert the time in cell **A2** to a time zone that is **four hours behind it**.

**Method 2: Convert Time Zones by Adding Hours**

=A2 + TIME(4, 0, 0)

This particular formula will convert the time in cell **A2** to a time zone that is **four hours ahead of it**.

The following example show how to use these formulas in practice.

**Example 1: Convert Time Zones by Subtracting Hours**

Suppose we have a list of date and times in Excel that are currently in Eastern Standard Time but we would like to convert them to Pacific Standard Time:

Since Pacific Standard Time is** four hours behind** Eastern Standard Time, we can type the following formula into cell **B2** to make this conversion:

=A2 - TIME(4, 0, 0)

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays each datetime in column A in terms of Pacific Standard Time.

Notice that each datetime in column B is exactly four hours behind each datetime in column A.

**Example 2: Convert Time Zones by Adding Hours**

Suppose we have a list of date and times in Excel that are currently in Pacific Standard Time but we would like to convert them to Eastern Standard Time:

Since Eastern Standard Time is** four hours ahead of **Pacific Standard Time, we can type the following formula into cell **B2** to make this conversion:

=A2 + TIME(4, 0, 0)

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays each datetime in column A in terms of Eastern Standard Time.

Notice that each datetime in column B is exactly four hours ahead of each datetime in column A.

For example, if it is January 1st, 2023 at 2:15 AM in Pacific Standard Time then it is January 1st, 2022 at 6:15 AM in Eastern Standard Time.

**Note #1**: You can use this formula to convert any datetime to another time zone if you simply know the difference in hours between the two time zones.

**Note #2**: You can find the complete documentation for the **TIME** function in Excel .

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel: