View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rocky Rocky is offline
external usenet poster
 
Posts: 18
Default Custom AutoFilter

Thanks Marcelo. I was bit confused.

Regards
Rocky

"Marcelo" wrote:

Hi Rocky,

the number 0,0173611111111111 is related to 00:25:00 in a general format,
so, you do not need to select 0:25 again.

hth
regards from Brazil
Marcelo


"Rocky" escreveu:

Suppose I have the following entries in a column:
0:20
0:21
0:22
.
.
.
0:30

Now I put a filter and select Custom. In the Customer Autofilter dialog box
if iselect "is less than and select 0:25" and click 'Ok', I get the correct
values. Now when I select Custom once again what is see is "is less than
0.0173611111111111" instead of "is less than 0:25". I have to select 0:25
once again in the drop down. This is very annoying. How can I solve this. Any
help is highly appreciated.