Notion Templates
Notion Templates/
All Templates
All Templates/
🎺
Track Working Hours
🎺

Track Working Hours

Master Tag
Workplace
Created
Aug 29, 2020 03:24 PM
How It Works
https://www.redgregory.com/notion/2020/8/29/notion-for-freelancers-track-paid-working-hours
Usage
dateBetween
minute
Divide
Web Tags
Database
Formula
Alternatives
Cover
💡
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.
Working Hours This Week
Hourly Rate
Input
Input 1
Input 2
Input 3
Input 4
Input 5
Input 6
Input 7
Total Hours
Add To Invoice
$30.00
Project 1
‣
‣
‣
‣
‣
‣
‣
$19.00
Project 2
$25.50
Project 3
$20.00
Project 4
$24.00
Project 5

Sum of all input properties:

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)

Add another input property?:

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"))
  • Also ... add another add( function to the first line

Formula with hourly rate:

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")
Â