<aside> 💡 Does your hourly rate stay consistant regardless of project type? Change "Hourly Rate" to a formula property type and insert your one rate. It will populate down the column.
</aside>
round(add(add(add(add(add(add(dateBetween(end(prop("Input 1")), start(prop("Input 1")), "minutes"), dateBetween(end(prop("Input 2")), start(prop("Input 2")), "minutes")), dateBetween(end(prop("Input 3")), start(prop("Input 3")), "minutes")), dateBetween(end(prop("Input 4")), start(prop("Input 4")), "minutes")), dateBetween(end(prop("Input 5")), start(prop("Input 5")), "minutes")), dateBetween(end(prop("Input 6")), start(prop("Input 6")), "minutes")), dateBetween(end(prop("Input 7")), start(prop("Input 7")), "minutes")) / 60)
before "/ 60
" and after "dateBetween(end(prop("Input 7")), start(prop("Input 7")), "minutes"))
" add this syntax:
, dateBetween(end(prop("Input 8")), start(prop("Input 8")), "minutes"))
add(
function to the first lineround(add(add(add(add(add(add(dateBetween(end(prop("Input 1")), start(prop("Input 1")), "minutes"), dateBetween(end(prop("Input 2")), start(prop("Input 2")), "minutes")), dateBetween(end(prop("Input 3")), start(prop("Input 3")), "minutes")), dateBetween(end(prop("Input 4")), start(prop("Input 4")), "minutes")), dateBetween(end(prop("Input 5")), start(prop("Input 5")), "minutes")), dateBetween(end(prop("Input 6")), start(prop("Input 6")), "minutes")), dateBetween(end(prop("Input 7")), start(prop("Input 7")), "minutes")) / 60) * prop("Hourly Rate")