• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Excel: trying to filter on time of >15 mins not working

I'm trying to fileter on a cell that has time as 0:00:00 and I want to get any that re over 15mins.
when I set the custom filter to pull the data it is not working. It seems to put a long number in the filter when I go back and look.  Can I do this with a custom filter or do I need to code it? If code how would I code it?  Thanks
0
newbeetocomputers
Asked:
newbeetocomputers
  • 2
1 Solution
 
dlmilleCommented:
please provide a sample workbook.

Dave
0
 
newbeetocomputersAuthor Commented:
Got it, it seems that the time was showing correct but it was not put in as number but text...
I'm good to go.
0
 
dlmilleCommented:
cool!
0
 
cdb424ttmCommented:
s
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now