» Rounding Times Down to the Nearest 30 Seconds
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Rounding the times ("hh:mm:ss") in column A down to the nearest 30 seconds.
Solution 1:
Use the ROUNDDOWN function as shown in the following formula:
=ROUNDDOWN(A2*24*120,0)/(120*24)
Solution 2:
Use the FLOOR function as shown in the following formula:
=FLOOR(A2,1/(24*120))
Book Store:
Recommended Books:
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- The Interpretation of Financial Statements
- Investing for Dummies, Third Edition
- Guide to Financial Reporting and Analysis
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
