I think the last formula should be - dateBetween(dateEnd(prop("Date")), dateStart(prop("Date")), "minutes")
@unoriginalsin10 ай бұрын
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.
@SebR-FR10 ай бұрын
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...
@bors1n5 ай бұрын
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.
@mluzu9610 ай бұрын
you're so awesome for making these vids! thank u!
@ProductiveSetups10 ай бұрын
haha glad I could help! :D
@kikokoussi75949 ай бұрын
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
@yeshuasveryown10 ай бұрын
You can go and edit the time if you forget to hit stop
@earthmoon43864 ай бұрын
how do you edit the time? 😩
@iwasbornataveryoungage4 ай бұрын
you saved me dude keep it up!
@labulabuland4 ай бұрын
manual 8:00 Formula 🌆 7:37
@jwladimirt9 ай бұрын
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.
@neilhoggard110 ай бұрын
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?
@ProductiveSetups10 ай бұрын
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 :)
@A_Seablue_Moon5 ай бұрын
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.
@XeiDaMoKaFE10 ай бұрын
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
@DarrenTechАй бұрын
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
@miryamartigas54814 ай бұрын
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!
@instaLuke2 ай бұрын
Ye okay, not bad, this was useful, thanks!
@TdotTbot4 ай бұрын
What if you are working on the same task over and over again on the same day?
@mariadamore19633 ай бұрын
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.
@funkyinferno3 ай бұрын
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.
@alex11-k2d10 ай бұрын
After using the first option the 'minutes' column won't show anything. Why?
@robinbroekhuis7 ай бұрын
What about time blocking in calander. But splitting/duplicating the task over 2 or 3 days. How would it calculate the total time.
@ProductiveSetups7 ай бұрын
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
@rosaclark96616 ай бұрын
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?
@ProductiveSetups6 ай бұрын
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