# Convert Time Zones in Excel & Google Sheets

This tutorial will demonstrate how to convert a time from one time zone to another time zone. To convert time values provided in one time zones to another time zone, you can use the following two methods.

## Simple Method

This is a simple way of converting time to a different time zone. Here, simply take the number of hours difference between the time zones, in column C, divide it by 24, and then add to the original time (column B):

``=B3+(C3/24)`` This simple formula works well because, in Column B, the Date is provided along with the time. However, if only the time was provided, you could run into issues where the formula doesn’t work.

Excel can not handle negative times. So here we attempting to subtract for hours from 01:00, which results in an error: ## Foolproof Method

If only the time is given and we need to convert it to different time zone, then we’ll use MOD function like this:

``=MOD(B5+(C5/24),1)`` The MOD function will return the remainder after a value is divided by its divisor. Also as Excel doesn’t show negative time values. So, if this formula (time + (hours/24)) returns a negative decimal value, then MOD will return the reciprocal value. E.g. if the formula returns -0.375 value, the MOD will return 0.625 i.e. equivalent to 3 PM. 