fill in hour in excel sheet
 

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

fill in hour in excel sheet
 

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

fill in hour in excel sheet
 

vee,

------------------------
A B
1 :04:34
2
3
..
..
------------------------

1) Select B1
2) Type 00:00:01 and press ENTER into B1,
and press DELETE to erase data in B1 (for Auto NumberFormat)
3) Enter a formula in B1:

=TIMEVALUE("00"&A1)

--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--