use a help column and a formula like

=MOD(A2;1)

copy down and sort by the help column


Regards,

Peo Sjoblom



"ColoradoKid" wrote:

I'm trying to sort a worksheet by a column that has both date and time in it,
and I would like to get rid of the date portion and sort strictly by time of
day.