» 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 22 Immutable Laws of Branding
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Keys to Reading an Annual Report (Barron's Business Keys)
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Special Edition Using Microsoft Word 2002
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
