» 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:
- The 11 Immutable Laws of Internet Branding
- Understanding Financial Statements
- Special Edition Using Microsoft Excel 2002
- Special Edition Using Microsoft Word 2002
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Advanced modelling in finance using Excel and VBA
No comments have been submitted.
