There is nothing built in but with a little bit of VBA as described here it
can be done. I have used a variation of this and it works great.

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

Jim Thomlinson


"EJamison" wrote:

Is there an easier way to enter time in an excel spreadsheet without typing
the : and AM or PM?