How would I cut out times under a certain amount?

[rmartori]

So I have documents that have a total duration in H:MM:SS and I need to remove any rows that are under 10-12 minutes(depending on the course.)

[mceleavey · Accepted solution]

Hi @rmartori ,

You need to convert the time into minutes using a simple formula:

DateTimeHour([Duration]) * 60 + DateTimeMinutes([Duration])

This gives you the amount of time in minutes.

Then you simply filter.

I've attached the workflow for you.

M.

[mceleavey]

...oops! It's working now.

[Qiu]

@rmartori 
Add a Datetime Tool in case the comng data is a string.