ExcelBanter - time entry-excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - time entry-excel (https://www.excelbanter.com/excel-discussion-misc-queries/237093-time-entry-excel.html)

EJamison

time entry-excel

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

Jim Thomlinson

time entry-excel

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?

All times are GMT +1. The time now is 11:40 AM.