Converting decimal number to hh:mm format
 

I have a large amount of data that I want to enter. I would like to enter it
in the format of #### ( i.e. 1234) and have it automatically converted to
12:34 PM. Is there a way to do this? If so, How?

Converting decimal number to hh:mm format
 

Chip Pearson shows how it can be done he

http://www.cpearson.com/excel/DateTimeEntry.htm

Hope this helps.

Pete

On Apr 15, 8:21*pm, Jeff Lowenstein
wrote:
I have a large amount of data that I want to enter. *I would like to enter it
in the format of #### ( i.e. 1234) and have it automatically converted to
12:34 PM. *Is there a way to do this? *If so, How?

Converting decimal number to hh:mm format
 

I agree...it is nice to avoid typing all the :

In A1 enter:
1234 (as text)
In B1 the formula: =TIME(--LEFT(A1,2),--RIGHT(A1,2),0)

For example A1 thru B3:

1234 12:34 PM
0830 8:30 AM
1440 2:40 PM


(as text allows the retension of the leading zero)


--
Gary''s Student - gsnu200779


"Jeff Lowenstein" wrote:

I have a large amount of data that I want to enter. I would like to enter it
in the format of #### ( i.e. 1234) and have it automatically converted to
12:34 PM. Is there a way to do this? If so, How?