I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.

--
Brian

My bet is that you have a mixture of real times and times entered as text--that
only look like time.

If you format that column as General, do your cells display numbers between 0
and 1?

(or maybe your cells contain dates and times and your cells are formatted to
show only the time???)

brianwakin wrote:

I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.

--
Brian

--

Dave Peterson

If I format the column as general I do have numbers between 0 and 1. My
cells are formatted to show only time (h:mm am/pm). I don't understand what
is going on here. If I hand type the same information in it sorts fine, if
the information is generated with a formula it won't sort right. Any
suggestions or more thoughts on this would be greatly appreciated. Thanks
for your reply.
--
Brian


"Dave Peterson" wrote:

My bet is that you have a mixture of real times and times entered as text--that
only look like time.

If you format that column as General, do your cells display numbers between 0
and 1?

(or maybe your cells contain dates and times and your cells are formatted to
show only the time???)

brianwakin wrote:

I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.

--
Brian

--

Dave Peterson

Ok.

How about this?

You have formulas that look like:

=sheet2!a2
=sheet2!a17
=sheet2!a29
=sheet2!a3

These kind of links don't work nicely with sorts.

If that's not it, you may want to post your a typical formula.

brianwakin wrote:

If I format the column as general I do have numbers between 0 and 1. My
cells are formatted to show only time (h:mm am/pm). I don't understand what
is going on here. If I hand type the same information in it sorts fine, if
the information is generated with a formula it won't sort right. Any
suggestions or more thoughts on this would be greatly appreciated. Thanks
for your reply.
--
Brian

"Dave Peterson" wrote:

My bet is that you have a mixture of real times and times entered as text--that
only look like time.

If you format that column as General, do your cells display numbers between 0
and 1?

(or maybe your cells contain dates and times and your cells are formatted to
show only the time???)

brianwakin wrote:

I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.

--
Brian

--

Dave Peterson


--

Dave Peterson

Here's a typical formula: =IF(AND($A7<"",$B7<"",$C7<""),$B7,"")

Thanks again.
--
Brian


"Dave Peterson" wrote:

Ok.

How about this?

You have formulas that look like:

=sheet2!a2
=sheet2!a17
=sheet2!a29
=sheet2!a3

These kind of links don't work nicely with sorts.

If that's not it, you may want to post your a typical formula.

brianwakin wrote:

If I format the column as general I do have numbers between 0 and 1. My
cells are formatted to show only time (h:mm am/pm). I don't understand what
is going on here. If I hand type the same information in it sorts fine, if
the information is generated with a formula it won't sort right. Any
suggestions or more thoughts on this would be greatly appreciated. Thanks
for your reply.
--
Brian

"Dave Peterson" wrote:

My bet is that you have a mixture of real times and times entered as text--that
only look like time.

If you format that column as General, do your cells display numbers between 0
and 1?

(or maybe your cells contain dates and times and your cells are formatted to
show only the time???)

brianwakin wrote:

I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.

--
Brian

--

Dave Peterson


--

Dave Peterson

And this formula is in Row 7??

If yes, I would guess that it works.

If it's not on row 7, then the sort will mess up what the formula points to--and
when the formulas get reevaluated, it'll look weird.



brianwakin wrote:

Here's a typical formula: =IF(AND($A7<"",$B7<"",$C7<""),$B7,"")

Thanks again.
--
Brian

"Dave Peterson" wrote:

Ok.

How about this?

You have formulas that look like:

=sheet2!a2
=sheet2!a17
=sheet2!a29
=sheet2!a3

These kind of links don't work nicely with sorts.

If that's not it, you may want to post your a typical formula.

brianwakin wrote:

If I format the column as general I do have numbers between 0 and 1. My
cells are formatted to show only time (h:mm am/pm). I don't understand what
is going on here. If I hand type the same information in it sorts fine, if
the information is generated with a formula it won't sort right. Any
suggestions or more thoughts on this would be greatly appreciated. Thanks
for your reply.
--
Brian

"Dave Peterson" wrote:

My bet is that you have a mixture of real times and times entered as text--that
only look like time.

If you format that column as General, do your cells display numbers between 0
and 1?

(or maybe your cells contain dates and times and your cells are formatted to
show only the time???)

brianwakin wrote:

I am trying to sort time values using a list. The time values in the cells
are calculated by a formula and not manually entered in. When I try and sort
them assending using a list it doesn't even come close to sorting correctly.
How do you sort using a list when the values are calculated by formulas?
Thanks. Any help would be greatly appreciated.

--
Brian

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson