Is there an easier way to enter time in an excel spreadsheet without typing the : and AM or PM?
E EJamison Jul 16, 2009 #1 Is there an easier way to enter time in an excel spreadsheet without typing the : and AM or PM?
J Jim Thomlinson Jul 16, 2009 #2 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
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
