These formulas worked perfectly Rick. Thank so much for your help... and a
few laughs inbetween :)

"Rick Rothstein (MVP - VB)" wrote:

Okay, we have lots of posts now and they are not all sequentially
arranged... so I'll address your question and sum up the two possibilities
in this message...

Did you see David's posting? He points out that you changed the text you
said you have to parse by adding an colon that was not in the original
posting... your text now reads ""20070917 at: 1900" - note the colon after
the word "at". If the colon is a mistake, remove it and use this formula...

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID (A1,13,2),RIGHT(A1,2),0)

or, if the colon belongs there, use this formula....

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID (A1,14,2),RIGHT(A1,2),0)

and then format the cell as Date using the "3/14/01 13:30" item from the
Type list.

Rick


"Titanium" wrote in message
...
Yeah... I got that one... but you're LIKELY going to want to shoot me when
i
tell you it doesn't work... The exactly same answer displays minus the
"at"
now... The time is missing one character so for 19:00 it displays 1:00.

"Rick Rothstein (MVP - VB)" wrote:

I guess we're both having a poor concentration day ;)

"differently. Put this formula...
"
/Insert formula here :)

ha ha

I hope by now that you have seen the follow-up posting I made to the
"missing formula" posting.

Rick