Gordon

You can have 915 show as 9:15 using a custom format, but it will not be a valid
time.

Only through VBA can you quick-enter dates/times as you want.

See Chip Pearson's site for this.

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


Gord Dibben MS Excel MVP

On Thu, 12 Jan 2006 13:16:13 -0500, "BigBuck98" wrote:

Sloth,
I have tried to format the cell with the time formats, but I can't seem to
get anything to work. I just want to type in 915 and have it show 9:15 or
1015 and have it show 10:15. I there a better way to do this?

Gordon

"Sloth" wrote in message
...
As confusing as it would be to do that, you can use a custom number format
of

#\:##

915 will appear as 9:15, and 1015 will appear as 10:15. Is that what you
wanted? Why would you do that though? Excel is very handy when dealing
with
time.

"BigBuck98" wrote:

Is there any way that I can format a cell to insert a colon three spaces
to
the left from the end of any group of numbers that I type in the a cell?
Examples 9:15 10:15

Thanks in advance,
Gordon