Do you think so? Have you tried it? [If so, on which version of Excel?]

Hints: Does sort base its results on the content of the cell, or on what is
displayed? Does the display format affect the content?
--
David Biddulph

"Mike H" wrote in message
...
Hi,

1 way.

Reformat your cell with the custom format of hh:mm
sort your cell in the desired way
Reformat back to dd/mm/yyyy hh:mm

Mike

"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?