» Rounding Hours Up
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
To round hours up:Use the CEILING formula.
The formula in cell D3 in the screenshot is:
=CEILING((C3-B3)/0.04167,1)
Note:
The number 0.04167 is a decimal value of 1/24.
Book Store:
Recommended Books:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Personal Finance for Dummies
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Wall Street Journal Guide to Understanding Money and Investing
- Financial Reporting and Analysis (2nd Edition)
- Accounting Principles, with CD, 6th Edition
No comments have been submitted.
