Entries

Totals

Notes

<aside> 👆 Just make sure the In and Out Point properties include 8 numbers and are formatted as follows: 00:00:00:00

</aside>

<aside> ⚠️ Requires the following properties: FPS + Frame Diff + Duration

</aside>

Frame Diff

(empty(prop("FPS")) or empty(prop("In Point")) or empty(prop("Out Point"))) ? toNumber("") : (toNumber(slice(prop("Out Point"), 0, 2)) * 3600 * prop("FPS") + toNumber(slice(prop("Out Point"), 3, 5)) * 60 * prop("FPS") + toNumber(slice(prop("Out Point"), 6, 8)) * prop("FPS") + toNumber(slice(prop("Out Point"), 9, 11)) - (toNumber(slice(prop("In Point"), 0, 2)) * 3600 * prop("FPS") + toNumber(slice(prop("In Point"), 3, 5)) * 60 * prop("FPS") + toNumber(slice(prop("In Point"), 6, 8)) * prop("FPS") + toNumber(slice(prop("In Point"), 9, 11))))

Duration

contains(format(prop("Frame Diff")), "-") ? "" : ((empty(prop("FPS")) or empty(prop("In Point")) or empty(prop("Out Point"))) ? "" : (format((floor(prop("Frame Diff") / (prop("FPS") * 3600)) == 0) ? "00" : (((length(format(floor(prop("Frame Diff") / (prop("FPS") * 3600)))) == 1) ? "0" : "") + format(floor(prop("Frame Diff") / (prop("FPS") * 3600))))) + ":" + format((floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) == 0) ? "00" : (((length(format(floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60))) == 1) ? "0" : "") + format(floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60)))) + ":" + format((floor(prop("Frame Diff") / prop("FPS") - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * 60 - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60 * 60) == 0) ? "00" : (((length(format(floor(prop("Frame Diff") / prop("FPS") - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * 60 - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60 * 60))) == 1) ? "0" : "") + format(floor(prop("Frame Diff") / prop("FPS") - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * 60 - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60 * 60)))) + ":" + format((prop("Frame Diff") - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * prop("FPS") * 3600 - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * prop("FPS") * 60 - floor(prop("Frame Diff") / prop("FPS") - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * 60 - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60 * 60) * prop("FPS") == 0) ? "00" : (((length(format(prop("Frame Diff") - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * prop("FPS") * 3600 - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * prop("FPS") * 60 - floor(prop("Frame Diff") / prop("FPS") - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * 60 - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60 * 60) * prop("FPS"))) == 1) ? "0" : "") + format(prop("Frame Diff") - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * prop("FPS") * 3600 - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * prop("FPS") * 60 - floor(prop("Frame Diff") / prop("FPS") - floor(prop("Frame Diff") / (prop("FPS") * 60) - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60) * 60 - floor(prop("Frame Diff") / (prop("FPS") * 3600)) * 60 * 60) * prop("FPS"))))))

<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 BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>