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

Users are saying about us...

  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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube