Time format
 

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

Time format
 

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" wrote in message
...
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

Time format
 

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" wrote:

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" wrote in message
...
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

Time format
 

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

"UH woodmaster" wrote in message
...
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" wrote:

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" wrote in message
...
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