» Separating Dates and Times
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:The values in column A are combined dates and times.
We want to create two new columns of data: one containing the date and the other containing the time.
Solution:
To extract dates, use the INT function as shown in the following formula:
=INT(A2)
Enter the above formula in column B and format as "mm/dd/yyyy".
To extract times, use the MOD function as shown in the following formula:
=MOD(A2,1)
Enter the above formula in column C and format as "h:mm".
Book Store:
Recommended Books:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Windows XP Inside Out
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The Financial Numbers Game: Detecting Creative Accounting Practices
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
