Thread: Easy Time Entry
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Easy Time Entry

Try this:

Format cells as 00\:00


"egibberate" wrote:

Hi,
Anyone know some code I could use to easily enter times into cells.
For example, I currently type '20:15' (without the quote's of course) but
would much rather type 2015 & have it appear as 20:15