convert date and time to different format

Hi All,

Can anyone please advise on a formula which would format the date and time.

Current string are like below:

Please Login or Register  to view this content.

The first field in date is the month and is 1 or digits and the same applies to the time hour field which is always labelled am or pm.

I would like this to be:

Please Login or Register  to view this content.

Just for clarity the source field is m/d/yy h:mm and I would like it to be dd/mm/yyyy hh:mm

Thanks in advance.

Try this ...

=DATE(2000+MID(A1,FIND(" ",A1)-2,2),LEFT(A1,FIND("/",A1)-1),MID(A1,FIND("/",A1)+1,FIND(" ",A1)-4-FIND("/",A1)))
+MID(A1,FIND(" ",A1)+1,5)+0.5*(RIGHT(A1,2)="PM")

Beautiful.....thank you so much