Round the time to nearest 10th minute

klllmmm

New Member
Joined
Nov 14, 2015
Messages
13
I have data set of times. I want to round the each time to nearest 10th minute. A sample of data set & expected answer is shown below.
Thanks you very much for your time.

8:11
8:10
7:57
8:00
8:03
8:00
4:33
4:30
5:08
5:10

<tbody>
</tbody>
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,312
Office Version
365
Platform
Windows
Try

=MROUND(A2,1/144)

(You may need to format the results as Time)
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top