Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter
Ok so I have another huge sections of data that I need to filter. This time
the column that I need to filter off of has a list of times that the ticket has been active in seconds. I need to filter out all tickets open less then 120 hours so that the only ones I have left are those that have been open 120 hours or greater. Is this even possible? P.S. Excel 2003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
never mind
I just found the custom option on the auto filter which allows me to select
greater than and then type a condition which in this case was 432000 and that works great but thanks anyways. "Chad Portman" wrote: Ok so I have another huge sections of data that I need to filter. This time the column that I need to filter off of has a list of times that the ticket has been active in seconds. I need to filter out all tickets open less then 120 hours so that the only ones I have left are those that have been open 120 hours or greater. Is this even possible? P.S. Excel 2003 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter
If the column has the number of seconds in it, then 120 hours is 432,000
seconds. So filter for anything greater than 432,000. If the column actually has Excel times, rather than number of seconds, then 120 hours is 5 days, so filter for anything greater than 5. Regards, Fred. "Chad Portman" wrote in message ... Ok so I have another huge sections of data that I need to filter. This time the column that I need to filter off of has a list of times that the ticket has been active in seconds. I need to filter out all tickets open less then 120 hours so that the only ones I have left are those that have been open 120 hours or greater. Is this even possible? P.S. Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |