Get Time Converter Template

To convert GMT to any other time zone, add or subtract the difference in hours divided by 24. Select the cell where you want the new time to appear, type =, followed by the cell containing the GMT and then add or subtract the time difference divided by 24. Press Enter.

To convert 18:00 UTC (6:00 p.m.) into your local time, subtract 6 hours, to get 12 noon CST. During daylight saving (summer) time, you would only subtract 5 hours, so 18:00 UTC would convert to 1:00 p.m CDT. Note that the U.S. uses a 12-hour format with a.m. and p.m. Other countries use 24-hour time.

Enter 6:45 in cell B2, and enter 9:30 in cell B3. In cell B4, enter =B2+B3 and then press Enter. The result is 16:15 16 hours and 15 minutes for the completion the two tasks. Tip: You can also add up times by using the AutoSum function to sum numbers. Select cell B4, and then on the Home tab, choose AutoSum.

To convert GMT to any other time zone, add or subtract the difference in hours divided by 24. Select the cell where you want the new time to appear, type =, followed by the cell containing the GMT and then add or subtract the time difference divided by 24. Press Enter.

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.

Just add(or subtract) the time needed: =A1 + Time(8,0,0) where 8 would be the number of hours to add. Scott Craner Dec 30 '19 at 20:29. So in this case, =A1+Time(5,30,0) , or =A1+5.5/24 . BigBen Dec 30 '19 at 20:30.

To convert 18:00 UTC (6:00 p.m.) into your local time, subtract 6 hours, to get 12 noon CST. During daylight saving (summer) time, you would only subtract 5 hours, so 18:00 UTC would convert to 1:00 p.m CDT. Note that the U.S. uses a 12-hour format with a.m. and p.m. Other countries use 24-hour time.

E5/24 // convert adjustment to Excel time. C5+(E5/24) =datetime+(hours/24)