Entries
Totals
Notes
Just make sure the
In and Out Point properties include 8 numbers and are formatted as follows: 00:00:00:00Requires the following properties:
FPS + Frame Diff + DurationFrame 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))))
Previous
Duration V1
(empty(prop("FPS")) or empty(prop("In Point")) or empty(prop("Out Point"))) ? "" : (format(floor(prop("Frame Diff") / (prop("FPS") * 3600))) + ":" + 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)) + ":" + 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")))
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"))))))
