» 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:
- Special Edition Using Microsoft Outlook 2002
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Access 2002 for Dummies
- Financial Risk Manager Handbook, Second Edition
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
