Help with Time (microseconds problem)

[naga]

Hello everyone,

I have a file which has 10 values in mm:ss.00 format.
Suppose if the time is 12:34.20 then the result should be 12:34.00 minutes.
And If the time is 12:34.60 then the result should be 12:35.00 minutes.

Kindly post some ideas.

Thanks in advance.

[Ace_XL]

Try

=MROUND(A1,1/86400)