» 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:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Retire Young, Retire Rich
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Special Edition Using Microsoft Access 2002
- Windows XP All-in-One Desk Reference For Dummies
- Dictionary of Finance and Investment Terms
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
