Hello everyone,

I need assistance with the formula, to also include time I have the date
converting properly, just need the time as well, for example:

Column A Converted

11022004 16:21 11/02/2004

Formula used TO CONVERT: =DATE(MID(A1,5,4),LEFT(A1,2),MID(A1,3,2))

Thanks for any help

Converting the time will work the same way:

=time(mid(a1,10,2),mid(a1,13,2),0)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Tracy" wrote in message
...
Hello everyone,

I need assistance with the formula, to also include time I have the date
converting properly, just need the time as well, for example:

Column A Converted

11022004 16:21 11/02/2004

Formula used TO CONVERT: =DATE(MID(A1,5,4),LEFT(A1,2),MID(A1,3,2))

Thanks for any help

=DATE(MID(A1,5,4),LEFT(A1,2),MID(A1,3,2))+TIME(MID (A1,10,2),MID(A1,13,2),0)

don't forget the format

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tracy" wrote in message
...
Hello everyone,

I need assistance with the formula, to also include time I have the date
converting properly, just need the time as well, for example:

Column A Converted

11022004 16:21 11/02/2004

Formula used TO CONVERT: =DATE(MID(A1,5,4),LEFT(A1,2),MID(A1,3,2))

Thanks for any help