On Fri, 23 Oct 2009 04:28:56 -0700, Nicola Blackie wrote:

Hi
I have been using a computer programme for some research which exports data to excel in the format of hours:minutes:seconds:tenth seconds
In order to perform my calculations I would like to round the data to hours:minutes:seconds and I can't seem to do it! Its driving me mad!
Please help, I am not neeading the acuracy of tenth second and do not want to delete the tenth second out of each cell as there are thousands!

PLease help

Thank you very much
Nicola

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Cookies FAQ
http://www.eggheadcafe.com/tutorials...okies-faq.aspx


You can use this formula in a "helper" column:

(assuming your original data starts in A1)

=ROUND(A1/TIME(0,0,1),0)*TIME(0,0,1)

Or, if you have the Analysis Tool Pak installed; or if you are using Excel
2007+, you could use:

=MROUND(A1,TIME(0,0,1))

Then fill down as far as necessary.

Then copy Paste Special Values and you should be done.
--ron