In case Kevin doesn't return, I'll answer the questions for him. No, it
doesn't work, because sorting operates on the entire cell contents, which are
still the date+time, regardless of the format you apply.

To sort by the time portion only, you must split it out into a separate
"helper" column using one of the methods already proposed.


On Tue, 30 Oct 2007 13:29:57 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Have you tried that, Kevin? Did it work? If so, which version of Excel?

Hints: Does sort base its results on the cell contents or on what is
displayed? Doe display format affect the contents?