vee,

For values starting in cell A1, in another cell, use the formula

=IF(LEFT(A1,1)=":",TIMEVALUE("0"&A1),TIMEVALUE(A1) )

and copy down. Format for time "hh:mm:ss" - the 13:30:35 example, then copy
and paste values over the formulas, and delete your original values.

HTH,
Bernie
MS Excel MVP

"vee" wrote in message
om...
Hi

Please help i need to covert these values:
:04:34 to be 00:04:34 in a excel sheet

these are time values & i dont know how.


another example
1:57:41-is correct
:08:35 needs to add 00 to be 00:08:35

thnks
vee