ExcelBanter - Date & Time function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date & Time function (https://www.excelbanter.com/excel-worksheet-functions/5813-date-time-function.html)

Tracy

Date & Time function

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)

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

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)

"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

All times are GMT +1. The time now is 09:06 PM.