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
Let’s take another example
CST is 6 hours earlier than GMT, so the result is correct.
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.