How to Convert GMT Time in Microsoft Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Converting a time in Microsoft Excel 2013 to or from Greenwich Mean Time requires a basic understanding of what GMT is and how it differs from the time zone you are converting it to. With this knowledge, you can convert any time to GMT or convert GMT to another time zone by adding or subtracting the time difference.

Advertisement

Understanding GMT

Video of the Day

GMT is a time zone used by the U.K. and some African countries, representing the mean solar time at the Royal Observatory in Greenwich, London. It was the world's first time standard until 1960, when it was replaced by Coordinated Universal Time, abbreviated UTC, as the world time standard. While GMT is now a time zone, just like Eastern or Mountain time, many people still refer to it as the standard, perhaps because it's synchronized with UTC.

Advertisement

Video of the Day

The U.K. is not always on GMT. From March to October, the U.K. is on daylight saving time, known as British Summer Time, which is one hour later than GMT.

Converting Current Time to GMT

Step 1

Image Credit: Screenshot courtesy of Microsoft.

Enter Excel's NOW function by clicking a cell and typing =NOW(). By itself, the NOW function returns the current date and time based on your computer's clock. Unlike most other functions, nothing goes in the parenthesis.

Advertisement

Step 2

Image Credit: Screenshot courtesy of Microsoft.

Calculate the number of hours between your current time zone and GMT. If you're located west of the U.K., add the time difference. If you're east of the U.K., subtract the hours. Because the NOW function is based on days, not hours, you need to add or subtract these hours from the NOW function divisible by 24 and then press Enter. For U.S. time zones, use:

Advertisement

Advertisement

  • =NOW()+5/24 for the Eastern time zone.
  • =NOW()+6/24 for the Central time zone.
  • =NOW()+7/24 for the Mountain time zone.
  • =NOW()+8/24 for the Pacific time zone.

If your time zone is currently using daylight saving time, add an additional hour.

Advertisement

Converting From GMT to Another Time Zone

Image Credit: Screenshot courtesy of Microsoft.

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. For U.S. time zones, use:

Advertisement

  • =NOW()-5/24 for the Eastern time zone.
  • =NOW()-6/24 for the Central time zone.
  • =NOW()-7/24 for the Mountain time zone.
  • =NOW()-8/24 for the Pacific time zone.

If the time zone that you want displayed is using daylight saving time, subtract an additional hour.

Advertisement

Advertisement

references