Microsoft Excel Functions & Formulas

Use the ROUND function to round time values

to whole hours

As in the previous tip, a worksheet contains time values including

hours, minutes, and seconds as shown in Figure 6-15. To round

these time values to whole hours, use the standard ROUND func-

tion. Recall that a day has 24 hours.

4

To round time values to whole hours:

1. In cells A2:A10 list some time values in this format:

12:02:59 AM.

2. Select cells B2:B10 and type the following formula:

=ROUND(A2*24,0)/24.

3. Press <Ctrl+Enter>.

160

Chapter 6

Figure 6-15