Round the time to nearest 10th minute

[klllmmm]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]8:11
[/TD]
[TD]8:10
[/TD]
[/TR]
[TR]
[TD]7:57
[/TD]
[TD]8:00
[/TD]
[/TR]
[TR]
[TD]8:03
[/TD]
[TD]8:00
[/TD]
[/TR]
[TR]
[TD]4:33
[/TD]
[TD]4:30
[/TD]
[/TR]
[TR]
[TD]5:08
[/TD]
[TD]5:10
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Try

=MROUND(A2,1/144)

(You may need to format the results as Time)

 

[klllmmm]

Found it,

=(ROUND((A1 * 1440)/10,0)*10)/1440

 

[klllmmm]

Thank you Mr. Peter_SSs.

It works..<strike></strike>

 

[Peter_SSs]

Thank you Mr. Peter_SSs.

It works..<strike></strike>

Glad to contribute.