Excel 2019 Bible

Part II: Working with Formulas and Functions

FIGURE 12.17

Calculating elapsed time

For more details on the IF function, see “Checking if a simple condition is met” in Chapter 13.

Rounding time values

It’s often necessary to round time to a particular increment. For instance, if you’re a con-

sultant, you may always want to round time up to the next 15-minute increment or down to

30-minute increments.

Figure 12.18 demonstrates how you can round to 15- and 30-minute increments.

FIGURE 12.18

Rounding time values to 15- and 30-minute increments

The formula in cell E4 is as follows:

=ROUNDUP(C4*24/0.25,0)*(0.25/24)