Time format

[UH woodmaster]

Can someone help me format some time cells. I need hh:mm:ss.# in two
adjancent cells. i would like to type 123456 and the result come to be
12:34:45.6.
I have tried custom formating, but the simple entry does not happen. I tried
an addon from the net but it will not except the decimal. ineed to be able to
subtract two time to creat a delta time. Manuall input is to time consuming.

Thank you

 

[Peo Sjoblom]

Why would it? One hour in Excel time is 1/24 so if you type
123456 it means that Excel sees it as a very large number of hours
(123456x24).
You would need a macro or a help formula, since you want this to happen
instantly I'd suggest the former

http://www.cpearson.com/excel/DateTimeEntry.htm


scroll down a bit to find the time entry

--


Regards,


Peo Sjoblom

 

[UH woodmaster]

Thank you for your help. i had found this program and do know how to modify
the code to fix my problem. I do not know how to install into excelor open a
vba code in excel.

 

[Peo Sjoblom]

Right click the sheet tab where you want this and select view code, paste it
in there.
Of course you need to change this part

Range("A1:A10")

to the range you need e.i.

Range("C2:C500")

if you enter times in C2:C500

--


Regards,


Peo Sjoblom