Converting decimal number to hh:mm format

[Jeff Lowenstein]

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?

 

[Pete_UK]

Chip Pearson shows how it can be done here:

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

Hope this helps.

Pete

 

[Gary''s Student]

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)