I have a custom attribute in my magento store say "duration". and it has values like "2 Hours", "180 Minutes", "1 day" etc. for display on frontend.
But now I want to filter product collection by this attribute.
For example : I want to filter products with less than "1000 minutes" duration. Collection must return those products which has value in
days (according to hour and day calculation).
Is it possible to filter product collection using this attribute? If yes then How to apply filter on product collection?