In the Formula Helper dialog box, please configure as follows. In the Choose a formula box, select Add hours to date. ... Select the cell with the date time you need to convert to another time zone in the Date Time box, Enter the time difference between these two time zones in the Number box, Click the OK button.