Hi,

I am looking for some help please.

I am trying to use the Text To Columns function within my VBA code, however, when trying to split a date and time in the following format: 28/04/2008 13:59:10 it is displaying my time as 03:59:10 with PM in text in the next again cell.

Is there anyway that I can have it so that it only displays my date in one cell and then the correct 24 hour time in the next cell?

Many thanks