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.
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...
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
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.
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 :)
The template has been very helpful so far. Is there a method on adding multiple dates + times for a task? I'm someone who can't finish a task in only one day so it'd be helpful if I can add the same task to multiple days.
I love this but is there a way to do this and be able to pause it?? I ask, because I work in help desk tickets and sometimes I have to pause it while I wait on a response
Hello! In the first method, would there be a way to create an option to “pause a task”? In case you don't finish a task in one go. It would be very useful!
Is there a way to see the time you've tracked as a calendar view? I'd love to see a comparison of what I've time blocked vs what I've actually done/tracked.
Seconding this. I'd like to know the answer! Or additional question, automatically add the time tracked via buttons to the calendar to have a nice week overview of the actual time spent doing stuff.
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
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?
I think the last formula should be - dateBetween(dateEnd(prop("Date")), dateStart(prop("Date")), "minutes")
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.
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 a lot. I was looking for a method to track my education and work time in notion, your first way is perfect for me.
you're so awesome for making these vids! thank u!
haha glad I could help! :D
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
you saved me dude
keep it up!
You can go and edit the time if you forget to hit stop
how do you edit the time? 😩
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.
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 :)
But can we count the time of a tag ?
I'd like to know how much time a member is in a tag state , with breaks when the tag is changed
The template has been very helpful so far. Is there a method on adding multiple dates + times for a task? I'm someone who can't finish a task in only one day so it'd be helpful if I can add the same task to multiple days.
Ye okay, not bad, this was useful, thanks!
I love this but is there a way to do this and be able to pause it?? I ask, because I work in help desk tickets and sometimes I have to pause it while I wait on a response
Hello! In the first method, would there be a way to create an option to “pause a task”? In case you don't finish a task in one go. It would be very useful!
manual 8:00
Formula 🌆 7:37
Is there a way to see the time you've tracked as a calendar view? I'd love to see a comparison of what I've time blocked vs what I've actually done/tracked.
Seconding this. I'd like to know the answer! Or additional question, automatically add the time tracked via buttons to the calendar to have a nice week overview of the actual time spent doing stuff.
What if you are working on the same task over and over again on the same day?
What about time blocking in calander. But splitting/duplicating the task over 2 or 3 days. How would it calculate the 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
After using the first option the 'minutes' column won't show anything. Why?
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?
Great question! I just add the task 3 times across the 3 days that way I can track the specific amount of time spent on each day