Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)

 

While working on Excel reports and Excel dashboards in Microsoft Excel, we need to convert Date and Time. In addition, we need to get the difference in timings in Microsoft Excel 2010.

To convert time in column A from GMT (Greenwich Mean Time) to CST (Central Standard Time), we can use the below mentioned formula.

CST is 6 hours earlier than GMT.

We can use the Time Function

  • Open Excel worksheet
  • In Cell A2 write 10:30:00
  • Write Formula in cell B2
  • =A2+1-TIME(6,0,0)
  • We will get the result as 04:30:00
  • CST is 6 hours earlier than GMT, so the result is correct

Converting Time

 

Let’s take another example

  • Open Excel
  • In Cell A2 write 12:00:00 AM
  • Write Formula in cell B2
  • =A2+1-TIME(6,0,0)
  • We will get result 06:00:00 PM

CST is 6 hours earlier than GMT, so the result is correct.

Converting time into decimal



3 thoughts on “Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)

  1. Actually this formula interprets the result as a negative time and therefore displays an error. Because 1 = 24 hours, the formula should read =A2+1-TIME(6,0,0).

    I just tested this converting 1:38 AM GMT to 5:38 PM PST (8 hours earlier)

  2. I tried it and it threw my off a day.
    The I have to use the entire Date AND GMT time. So, the formula added a day when in fact it is only 6 hours earlier.
    Date/Time Given: 07/11/2014 07:27 AM
    Date/Time Calculated: 07/12/2014 01:27 AM
    If fact the correct result should be: 07/11/2014 01:27 AM

    Taking out the “+1″ resolved it. So, why is it there?

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>