Splitting Date & Time Into 24 Hour Time

I have a spreadsheet that I need to split the date and time out to seperate columns.

The format is as such: 28/04/2008 15:03:05 in column AN

When I run a text to columns splitting on spaces through my macro it displays the time as 03:03:05 in Column AO and PM in Column AO.

Please Login or Register  to view this content.

Can anyone correct this as I need to copy the date from AN and also the Time from AO. The time needs to be in 24 hour format in order for my comparison to work properly.

Thanks in advance!

Try adjusting your Array information.

Please Login or Register  to view this content.

Thanks for getting back to me!
Still doesnt work unfortunately!

It seems to work if I was to do it within the workbook itself as a record macro function.

However, as soon as I add the code into the existing vba code it spits out this result rather than the 24 hour time.

Anyone able to add further help?

Anyone?

Thanks

Seeing as the code posted so far works you will have to supply more information regarding the exsiting code where it does not work.

Andy,

Thanks for getting back to me again.

See attached:

Run macro and you will see what it is doing.

Thanks

Brian

Thanks,

I can see the problem but not a solution using the current code.
It must format the date into dd/mm/yyyy hh:mm:ss AM/PM before spliting on spaces.

How about splitting on widths?

Please Login or Register  to view this content.

Thanks Andy.

I think I will use that solution for the time being.

If you have any other thoughts or solutions, please give me a shout!

Thanks again