Turn Text into Date and Time

[Kingnight]

Hey,

Thanks a lot for your time. I have one text 20110912, how could i turn that into this ( I want time to be exact 1:00:00pm)

09/12/2011 1:00:00 pm.


Thanks

 

[VoG]

Try

=DATE(LEFT(A1,4),RIGHT(A1,2),MID(A1,5,2))+"13:00:00"

Format the result cell as desired.

 

[Joe4]

Say your text is in cell A1, then use this formula and format with the appropriate date/time option:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))+13/24

 

[T. Valko]

Hey,

Thanks a lot for your time. I have one text 20110912, how could i turn that into this ( I want time to be exact 1:00:00pm)

09/12/2011 1:00:00 pm.


Thanks

Try this...

=TEXT(A1,"0000-00-00")+TIME(13,0,0)

Format as mm/dd/yyyy h:mm:ss AM/PM

 

[Kingnight]

Thank you so much for all of your help!!!!!!

 

[T. Valko]

Thank you so much for all of your help!!!!!!

You're welcome. Thanks for the feedback!