» 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 Windows XP Registry Guide
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Accounting the Easy Way
- Microsoft Windows XP Inside Out
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Marketing Planning for Services
No comments have been submitted.
