Time formatting - Excel 2003
I am downloading information from a website that uses the format 2:30'52'' (2 hours, 30 minutes, 52 seconds) into an excel spreadsheet, and I want to convert it to the format 2:30:52 so I can add and subtract the time.
It seems that excel is not recognising this format. Is there any way I could convert it to the correct format without doing it manually?
Thanks
|