» Rounding Times Down to the Nearest 30 Seconds
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Financial Statement Analysis with S&P insert card
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Marketing Planning for Services
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
No comments have been submitted.
