» Rounding Hours Up
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
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:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Special Edition Using Microsoft Outlook 2002
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Retire Young, Retire Rich
- Marketing Plans That Work, Targeting Growth and Profitability
- Business Plans Kit for Dummies (With CD-ROM)
No comments have been submitted.
