|
» Rounding Hours Up
CATEGORY: Excel Time |
VERSIONS: 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. |
| Screenshot // Rounding Hours Up |
  |
|
RATING:
2.79
VIEWS: 17955 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- The Analysis and Use of Financial Statements
- East of Eden (Oprah's Book Club)
- Business Plans For Dummies®
- Microsoft Office XP Introductory Concepts and Techniques
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
