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: