Red Gregory

View Original

Notion For Freelancers: Track Paid Working Hours

At the end of each row is a “total” calculation of hours

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)

As well, implement an “hours worked” property to return monetary value

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) * prop("Hourly Rate")

View Example In Notion


See this gallery in the original post