ExcelBanter - Time formatting

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time formatting (https://www.excelbanter.com/excel-worksheet-functions/7538-time-formatting.html)

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?

only using VBA. One way:

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

In article ,
"danlinksman" wrote:

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?

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

-----Original Message-----
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?
.