Tip Printed from ExcelTip.com

---

Rounding Hours Up


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.