» Rounding Times Down to a Specified Time Increment
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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 Fall of Advertising and the Rise of PR
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Windows XP Annoyances
- 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 Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Windows XP Inside Out
No comments have been submitted.
