Time formatting

[danlinksman]

Is there a way to enter a time valus such as 4:36 without the colon and still
have it appear as a time value. Example 4:36 would be entered as 436 on the
numeric keyboard and once entered it would change to 4:36?

 

[JE McGimpsey]

only using VBA. One way:

http://cpearson.com/excel/datetimeentry.htm

 

[Jason Morin]

With a formula in another column you could use:

=TEXT(A1,"00\:00")*1

but that assumes you enter your times as military (436 =
4:36 am, 1422 = 2:22 pm). Or you could enter them as
222pm, 1004am, etc. (no space) and use:

=REPLACE(REPLACE(A1,(LEN(A1)=6)+2,,":"),LEN(A1),," ")+0

HTH
Jason
Atlanta, GA