Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
Formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
Conditional formatting excel 2003 | Excel Discussion (Misc queries) | |||
Application coded in excel 2000 when used in excel 2003 excel doesnot perform well and takes double the time to give the output | Excel Programming | |||
excel 2003 formatting | Excel Discussion (Misc queries) |