Converting text into time

[Michelle]

Help!! Does anyone know how to convert a four digit number
into time, eg. 1215 to 12:15am? I have reports from
another program that can only be saved as text files so
when I open up these files in Excel, all my times are in
text and I need to find a way to convert them back into
time. Any suggestions would be most appreciated!!

 

[Aladin Akyurek]

Try also...

=--TEXT(A1,"0\:00")

Format the formula cell as time.

 

[ecphuah]

please use the following formula:

=left(cell position,2)&":"&right(cell position,2)

From
EC Phuah

 

[Mike]

eg. 1215 to 12:15am?

Is it true?
If yes, what is the four digit number of 12:15pm?

eg. 0015 to 12:15am and 1215 to 0:15pm?

 

[Michelle]

Hi everyone,

Thank you so much for all your suggestions ... I'm going
to have fun trying them all out!!

PS: Mike - thanks for pointing out my error: 1215 was
meant to equal 12:15pm.