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

Time formatting - Excel 2003
 

Hi Chris,

Am Fri, 15 Jun 2012 03:29:52 +0000 schrieb ChrisJM:

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.

try it with replace:
replace = find '' replace (nothing)
replace = find ' replace :


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2