Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Name: Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).
Brand: Quizplus
Rating: 4.9 (28 reviews)

Question

Quizplus · Accepted Answer

The correct formula to round a time to the nearest 30-minute interval is =MROUND(A4,"0:30") or =MROUND(A4, TIME(0,30,0)). The time interval should be specified as a time value, not a text string.

Cell A4 Contains the Time 10:27 Pm