» Rounding Times Down to a Specified Time Increment
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Rounding the times in column A down to the nearest 15 minute increment.
Solution:
Use the TIME, FLOOR, HOUR, and MINUTE functions as shown in the following formula:
=TIME(HOUR(A2),FLOOR(MINUTE(A2),15),0)
Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Excel VBA Programming for the Absolute Beginner
- Excel 2002 Power Programming with VBA
- Accounting Principles, with CD, 6th Edition
No comments have been submitted.
