Time Duration as VALUE in Logical Formulas

Hello Everyone,

This is my first post. Excited to be here will all of you. So, here is my issue; I have a document with running times of videos. If the video meets my requirements I have a logical formula set to it, that will SUM the total time of requirement-met videos. Now, I am trying to set the below formula so that even if a video meets my requirements, ONLY 20 minutes (0:20:00) of that video will be added to the total sum.

I am running into the issue that when I try and change the value of "20" to "0:20:00", the formula no longer recognizes "0:20:00" as a value and my formula has an error.

Below is my current formula.


=IF(Sumif($G$2:$G$1000,"Y",$F$2:$F$1000)>=20,20,SUM(Sumif($G$2:$G$1000,"Y",$F$2:$F$1000)))


Can you please help?

Try "0:20:00"+0

Also FYI, the way you did it is not wrong persay
But instead if
IF(calculation>=20,20,calculation)
Try
MIN(20, calculation)