Duration as a report filter

Elenka Refsell

I'm trying to set up a report of my to-dos that have a duration of 5m or less but am having trouble setting up a duration filter based on anything other than whole days. I know I could probably create a custom column  in every sheet with a checkbox to say the task takes 5 min. or less or a formula converting the duration field in to a set number, but I've got a lot of sheets that already overwhelm some of my users and I'd rather not add yet another column to the mix.

 

Has anyone been able to successfully create a report along these lines?

 

Thanks!

Brett Evans

This formula should do it.

=IF(Duration1 < 0.01043, "Less than 5 min", "Greater than 5 min")

Kennedy Stomps

Great suggestion, Brett! You could "hide" the column, Elenka, which will keep it from being visible to your users and making your sheet overwhelming