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
5. We will get the result as 04:30:00
6. CST is 6 hours earlier than GMT, so the result is correct
Let’s take another example
1. In cell A2 write 12:00:00 AM
2. Write the formula in cell B2
4. We will get the result as 06:00:00 PM
CST is 6 hours earlier than GMT, so the result is correct.
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.
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.