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

In this article we will learn how to convert date and time from GMT to CST in Microsoft Excel 2010.

While working on reports and dashboards,we need to convert Date and Time from one timezone to another. In addition, we need to get the difference in timings.

To converttime in column A from GMT (Greenwich Mean Time) to CST (Central Standard Time), we can follow the below steps -

CST is 6 hours earlier than GMT.

We can use the Time function

1. Open an Excel spreadsheet
2. In cell A2 write 10:30:00
3. Write this formula in cell B2
4. =A2+1-TIME(6,0,0)
5. We will get the result as 04:30:00
6. CST is 6 hours earlier than GMT, so the result is correct

 

img1

 

Let’s take another example

1. In cell A2 write 12:00:00 AM
2. Write the formula in cell B2
3. =A2+1-TIME(6,0,0)
4. We will get the result as 06:00:00 PM

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

 

img2

 

Similarly we can do the conversions for the other time zones as required, taking into consideration the difference between the time zone and the GMT time.

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