Planning, Templates

Freelance Hourly-Rate Log In Notion

Screen Shot 2020-01-27 at 9.41.48 PM.png

💲 Hourly-Rate Calculator

This template is intended for those seeking an hourly-rate or a clock in-clock out calculator in Notion. This is great for freelancers logging hours and keeping track of tasks that have been completed, those currently being worked on and tasks for the future.

This little template can be paired with a master sprint plan, content calendar or general workspace dashboard if so desired. I would get creative with relations in this case. I have not implemented it as of yet into my work page due to a pause to my client work, but I will be using it in the future. This is something I’ve always wanted - an hours logged per task database. My log has only one property for hourly-rate of which requires an amount of money earned per hour input, however, I’m aware some freelancers have multiple hourly rates for certain projects. In this case I would turn the hourly-rate formula into an “IF statement” (example below).

Hours Logged Formula:

dateBetween(prop("Clock Out"), prop("Clock In"), "hours")

Pay-Out Formula:

prop("Hours Logged") * prop("Hourly-Rate")

Customize hourly-rate formula in relation to certain project type:

if(prop("Job") == "INSERT JOB HERE", #, if(prop("Job") == "INSERT JOB HERE", #, 0))

COPY TEMPLATE