Posted to microsoft.public.excel.worksheet.functions
|
|
Change time format from :0 to 0:0
Thank you both... both formulas work great!
"Sandy Mann" wrote:
:42:01
:02:58
:04:45
:25:13
are all Text not times try using this formula in a newly inserted column:
=("0:"&(SUBSTITUTE(J1,":","",1)))+0
then copy and paste the column back as Paste Special values and reformat
the column as time then delete the original column.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Donald B" wrote in message
...
I have tons of times in this format:
:42:01
:02:58
:04:45
:25:13
and need to change to:
0:42:01
0:02:58
0:04:45
0:25:13
Pls help...
tia
Donald
|