Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i get an form to fill up my excel sheet? | Excel Discussion (Misc queries) | |||
24 hour time sheet | Excel Worksheet Functions | |||
auto fill from another sheet in excel | Excel Worksheet Functions | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
MIcrosoft Excel: should allow sheet increase by 1 on fill down | Excel Discussion (Misc queries) |