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