Entering Time without the colon.......

[SCExcel]

I would like for a user to enter a time without the colon, for example, 1045, and have it appear in the cell as 10:45. Is this possible?

 

[Peo Sjoblom]

See:

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

it takes VBA

A non macro solution would be to use the numpad and temporary change
autocorrect
.. (period) to : (colon) that way you can use your right hand to type
with

--

Regards,

Peo Sjoblom

I would like for a user to enter a time without the colon, for example,

1045, and have it appear in the cell as 10:45. Is this possible?

 

[CLR]

Right-click on the cell(s) > Format Cells > Custom > type ##":"## in
the window > ok

Vaya con Dios,
Chuck, CABGx3

I would like for a user to enter a time without the colon, for example,

1045, and have it appear in the cell as 10:45. Is this possible?

 

[Peo Sjoblom]

Hi Charles,

it will only change the display, the underlying value would still be one
1,045

 

[SCExcel]

Thank you.......

----- CLR wrote: -----

Right-click on the cell(s) > Format Cells > Custom > type ##":"## in
the window > ok

Vaya con Dios,
Chuck, CABGx3

I would like for a user to enter a time without the colon, for example,

1045, and have it appear in the cell as 10:45. Is this possible?