To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval,the formula: =MROUND(A4,0:30)can be used.

Name: To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval,the formula: =MROUND(A4,0:30)can be used.
Brand: Quizplus
Rating: 4.8 (35 reviews)

Question

Quizplus · Accepted Answer

The correct formula to round time to the nearest 30-minute interval in Excel should use the TIME function for the interval part, like =MROUND(A4, TIME(0,30,0)). The format 0:30 is not recognized by Excel in formulas.

To Round Time 10:30 Pm Inserted in Cell A4 to the Nearest