|
» Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
CATEGORY: Excel Date & Time Formulas |
VERSIONS: All Microsoft Excel Versions |
|
Problem: Converting the dates and times in column A from GMT (Greenwich Mean Time) to CST (Central Standard Time). CST is 6 hours earlier than GMT. Solution: Use the TIME function as shown in the following formula: =A2-TIME(6,0,0) |
|
RATING:
3.32
VIEWS: 29187 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Not-for-Profit Accounting Made Easy
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Accounting the Easy Way
- Adventure Capitalist: The Ultimate Road Trip
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
Related MS EXCEL TIPS:
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.
