Date calculation and comparisons

Ask for Help
1

Not sure if there is already a guide to this.

Formula Durations = (now -createdDate)/60
Response is 02:30:05

i.e 2 hours, 30mins and 05 seconds

I want to use a comparison operator in the filterUI to show a record if Duration > (60mins)

How do I do this ? Seems like I need to do some conversion somewhere but I can’t figure it out.

2

So do you mean you need to convert that duration to minutes, and compare it to 60 mins?

3

yes please.

4

found another post

round((now - creat)*24,2)*60

Thanks for all help