If you find yourself forgetting to have your End Time before Start Time when filling out your formulas, just wrap the whole thing in an abs() to automatically convert the negative times to positives.
For the first method, you can add another category called Status, and in the button property, below the "Do this", add another property to set the status to "in progress" for start button, and "done" for end button. This will prevent accidental miss
That's fun, I've just discovered Notion few days ago and yesterday evening I was working on time tracking for task management and get to the same button solution but with extra actions who modify also a status prop... that's a visual confirmation you clicked on the buttons (problem, that doesn't prevent you to click multiple time on them...) Then I struggled to emulate a "pause" button...
Thanks for the vid, very good content. A quick question - if I was to use option 1 and then forget to hit the end button, could I open up the start and end columns and manually update the end date? That way I can use auto time tracking but can still fix when I forget to stop or I already started a task but didn’t hit start immediately. Maybe not hide those two columns so you can see the value and change if required. Not sure if the Notion DB can do this?
hey, good question :) no sadly not, since it is a formula. if you were to type anything in that column you'd be changing the formula code itself. Hence I recommend against buttons, and either manually type it in or use Notion Calendar :)
Hi, your tutorial is useful, however, I am trying to create a clock in/out databases for a job team, and I am not sure if your first method allows accumulating the worked hours. Because when I try to restart the cycle of time tracking, it is like the time gets restarted, losing the previous register. And also, if not easy to identify when a particular bottom is activated.
How do you handle working on the same tasks over several days? In other words, you're working on the same task on and off. Is there a way to roll up total total time?
In Notion Calendar App? Yeah, so you would split them up as seperate "intervals" and then if they're all labeled under the same Project then it adds up that time :D