Date & Time function

[Tracy]

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

 

[Fred Smith]

Converting the time will work the same way:

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

 

[Bob Phillips]

=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)