Converting text into time

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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!!
 
please use the following formula:

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

From
EC Phuah
 
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?
 
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.
 
Back
Top