» 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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Microsoft Windows XP Inside Out
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Windows XP Step by Step (With CD-ROM)
- Microsoft Windows XP Inside Out
- Windows XP for Dummies
No comments have been submitted.
