time trouble

[darkbearpooh1]

is it possible to format cell to enter times as example : 12:00, 1:30, 7:30

i figured out how but puts time in as military as in 13:00, 14:30 ect...
also anyone have any typing hints on entering times fast? not that i am being lazy although i am, but entering a lot of times when you have to hit shift
and find the numbers for the : is a pain... probably doesn't exist but i am looking for a formated cell or something to simplify this task? so maybe then i could just use number pad and hit like 12.3 to = 12:30 or something similiar thanks in advance

[Bob Phillips]

You can format the cells as hh:mm AM/PM, not quite what you want, but
someways.

On the input, see http://www.cpearson.com/excel/DateTimeEntry.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"darkbearpooh1" <[email protected]>
wrote in message
news:[email protected]...
>
> is it possible to format cell to enter times as example : 12:00, 1:30,
> 7:30
>
> i figured out how but puts time in as military as in 13:00, 14:30
> ect...
> also anyone have any typing hints on entering times fast? not that i am
> being lazy although i am, but entering a lot of times when you have to
> hit shift
> and find the numbers for the : is a pain... probably doesn't exist but
> i am looking for a formated cell or something to simplify this task? so
> maybe then i could just use number pad and hit like 12.3 to = 12:30 or
> something similiar thanks in advance
>
>
> --
> darkbearpooh1
> ------------------------------------------------------------------------
> darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
> View this thread: http://www.excelforum.com/showthread...hreadid=510439
>