Project Time Tracker

Project Time Tracker

Tags
Productivity
Time
Formulas
Projects
Tasks
Analytics
Functions
if
floor
dateBetween
dateEnd
toNumber
A project time tracker in Notion is a database that allows you to track the time you spend on different tasks and projects. This can be helpful for improving your productivity, and managing your time more effectively. In addition to tracking time lapsed in date-time ranges, group and calculate total time spent by projects, month, or week.
A project time tracker in Notion is a database that allows you to track the time you spend on different tasks and projects. This can be helpful for improving your productivity, and managing your time more effectively. In addition to tracking time lapsed in date-time ranges, group and calculate total time spent by projects, month, or week.
 
Time Tracker
Project A
Task
Work-span
Done
Hours + Min
Done
Done
Project B
Task
Work-span
Done
Hours + Min
Done
No description
Task
Work-span
Done
Hours + Min
 
Copy the code
 
if(prop("Done"), floor(100 * dateBetween( prop("Work-span").dateEnd(), prop("Work-span"), "minutes" ) / 60 ) / 100, toNumber("") )
String alternative (#hr #m)
if(prop("Done"), dateBetween( prop("Work-span").dateEnd(), prop("Work-span"), "hours" ) + " hr " + dateBetween( prop("Work-span").dateEnd(), prop("Work-span"), "minutes" ) % 60 + " m", "" )
 

☕ Buy me a coffee