Using a helper column:

B1: =MOD(A1,1)

Copy down as far as necessary. Sort.


In article ,
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?