Rounding Time and Cut and Paste issues

[acfilban]

I have this long list of times and I need to round each in this manner;
0-29 seconds stay the same
30-59 seconds round up a minute
So if the time is 14:05:29 it should read 14:05
And it the time is 22:13:30 it should read 22:14.
Is there a function for this?

Also like below, If I create a new column to the right using a function to round off these times, it's dependent on the column(original list of times) to the left isn't it?
23:44:12 23:44
18:22:45 18:22
02:03:34 02:04
13:45:46 13:46
I suppose if I wanted to, I can't just delete the column to the left without messing with the figures in right hand column. I'm wondering if there is a way I can round these figures in a similiar manner to changing the format of the cells so that I don't have to create another column altogether. Or instead, is there a way that I could cut and past the rounded off times(just the numbers) from the right column to anywhere else in the document without carrying the function quality?
Thank you Kindly,
Anna

[martindwilson]

try
=ROUND(A1*1440,0)/1440
then copy paste special values to somewhere else you can then delete originals and formulas

[acfilban]

Thanks! As for the other issue, I just copied my newly rounded column in Excel, pasted it into Microsoft Word, then pasted that back to Excel and the whole problem with pasting the unwanted function is now gone. Saved so much time. Thanks again!