fill in hour in excel sheet

V

vee

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
 
B

Bernie Deitrick

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
 
S

Soo Cheon Jheong

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
_ _
^¢¯^
--
 
Top