Insert a column to the right of your Data/Time column and enter the following
formula adjusting the cell address to your worksheet layout:

=TIME(HOUR(A1),MINUTE(A1),SECOND(A1))

Then copy down the column as far as necessary.

--
Kevin Backmann


"sot" wrote:

I have a list with a field in that the date and the time and these cells are
in the date and time format. (dd/mm/yyyy hh:mm). I need to be able to use
the time part of the data on its own and sort it into time order. Is this
possible?