» 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:
- Financial Peace: Revisited
- The Guide to Understanding Financial Statements
- Positioning: The Battle for Your Mind
- Marketing Plans
- Microsoft Windows XP Inside Out
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
