Have a huge excel sheet with thousands of times from an Ironman competiton. All times and split times have been written in the format 08.11.15. I need this converted to the 08:11:15 format so that I can then convert this to seconds and continue with statistics. I have thought of using decimals also, however, then one loses the second, which is not good in this case. Anyone out there who can help. The 08.11.15 format is in the "general" format and have already tried to see if I could get the numbers to change by changing the formatting. Does not work. Thanks.
Hi Mike, Thanks. My wish was to transfer the hh:mm:ss to all seconds. I did have the formular for this and yesterday I figured out to copy paste the columns into word, find and replace all . with : , copy paste again back into excel and voila my formula worked and I got seconds. Thanks for taking the time to answer though. Hans
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.