On Wed, 21 Sep 2005 16:16:02 -0700, "Howdy"
wrote:

Thanks to both Jim and Ron. Question for Ron: I have a spreadsheet with
several time columns. If I want to sort manually through the sort feature do
I still use the same formula?

Thanks again in advance

I don't understand what you mean by "sort manually"?

But I would suggest that if you want Excel to sort your values in TIME order,
that you first change your text values to Times. The formula (and process of
copy/paste special - values) that I outlined is one way of doing conversion.

If you have some other method of doing the conversion, then you could use your
method.


--ron