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.
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 :)
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
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!
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.
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
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.
manual 8:00
Formula 🌆 7:37
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 :)
You can go and edit the time if you forget to hit stop
how do you edit the time? 😩
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...
you saved me dude
keep it up!
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
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!
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.
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.
What if you are working on the same task over and over again on the same day?
you're so awesome for making these vids! thank u!
haha glad I could help! :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?
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
After using the first option the 'minutes' column won't show anything. Why?
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
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