<aside> ⚠️ Duration must be entered as 00:00:00 or 00h 00m 00s for Total Min to be calculated correctly.

</aside>

Entries

Total Min

ceil(toNumber(slice(replaceAll(prop("Duration"), " ", ""), 0, 2)) * 60 + toNumber(slice(replaceAll(prop("Duration"), " ", ""), 3, 5)) + toNumber(slice(replaceAll(prop("Duration"), " ", ""), 6, 8)) / 60)

QC Rate

if(prop("Type") == "Option 1", if(prop("Total Min") <= 3, 1, if(prop("Total Min") <= 5, 1.5, if(prop("Total Min") <= 10, 3, if(prop("Total Min") <= 20, 6, if(prop("Total Min") <= 30, 9, if(prop("Total Min") <= 45, 13, if(prop("Total Min") <= 60, 18, if(prop("Total Min") <= 75, 22, if(prop("Total Min") <= 90, 26, if(prop("Total Min") <= 105, 31, if(prop("Total Min") <= 120, 35, if(prop("Total Min") <= 135, 39, if(prop("Total Min") <= 150, 44, if(prop("Total Min") <= 165, 48, if(prop("Total Min") <= 180, 53, if(prop("Total Min") <= 195, 57, 61)))))))))))))))), 2.5)

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>