» 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:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Analyzing Markets, Products, and Marketing Plans
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- How to Read A Financial Report
No comments have been submitted.
