Time formatting - Excel 2003

C

ChrisJM

I am downloading information from a website that uses the forma
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 subtrac
the time.

It seems that excel is not recognising this format. Is there any way
could convert it to the correct format without doing it manually?

Thank
 
C

Claus Busch

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.
Click to expand...

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


Regards
Claus Busch
 
Top