ExcelBanter - View Single Post

Wrote:
I need help creating a macro that lets you type in 7p that will show up
as 7:00 PM. Is this possible?

Thanks
Lori

Why dont you just set the cell format in Excel to h:mm AM/PM in the
Format_cells_custon options and type hour element of the time in 24hr
format. e.g. you would just need to type in 19: for 7pm. This is what
most people commonly do and is simpler that setting up macros etc.

--
525047