» 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:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Special Edition Using Microsoft Excel 2002
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Microsoft Excel 2002 Simply Visual
- PowerPoint® 2002 For Dummies®
No comments have been submitted.
