Time Tracking in Notion Using NEW Notion Buttons!
HTML-код
- Опубликовано: 30 июл 2024
- 🧠 Notion Second Brain Template:
creativecovehq.etsy.com/uk/li...
⚡ Get my Notion templates:
creativecovehq.etsy.com
In this Notion tutorial, I show you how to build a time tracker in Notion to help you keep track of how many hours you work.
This Notion timesheet is super useful especially if you work with clients.
🕝 Timestamps:
0:00 - Intro
0:13 - How to timesheet works
2:17 - Set up the database
4:45 - Formula that works out hours worked
8:38 - Add buttons to automatically fill out timesheet
12:13 - Set up today's view
13:01 - Set up analytics tabs
15:43 - Tidy up & improve aesthetics
A good tutor who knows how to teach in an easy understood manner! Two thumbs up
Thank you! I'm glad you found the video useful :)
Hey so i didnt like the (1.25 hours) format so i wrote this formula to convert hours into hours and minutes. hope this helps:
(if(dateBetween(prop("End Time"), prop("Start Time"), "minutes") < 60, dateBetween(prop("End Time"), prop("Start Time"), "minutes") + "min", floor(divide(dateBetween(prop("End Time"), prop("Start Time"), "minutes"), 60)) + "h " + mod(dateBetween(prop("End Time"), prop("Start Time"), "minutes"), 60) + "min")
this formula will make 35 = 35 min and 90 = 1h 30min
I really like this, but I'm not able to analyze how much time I spend on a certain type of task because is looks like Notion can't sum up timeformats together. Do you know how I can fix that? 🙂
Thank you so much, that was so helpful !
Thanks so much for this video! I was able to add this function to my accountability group Notion task planner along with a pomodoro! Now we can do some cool stuff while we plan our Q2
Great video !!
Great video! Instructions were clear throughout. Thank you for this.
Glad it was helpful!
Thank you! This tutorial was awesome!
Glad you enjoyed it!
Excellent! This replaced my old time tracker, wherein I had to set the start and end dates/times manually.
That's great, I'm glad you liked the video!
Thank you for doing this tutorial ❤ I've been looking for a Notion Time time tracker and couldn't find anything suitable to me and then you posted your video! it was great timing 😊 I made my own one alongside your video and finished it. Will be using for my different projects. I'm so glad I've found your channel.
Thank you! I'm glad you found the video helpful :)
@@creative_cove Keep up the great work! Hopefully we'll see a tutorial of Tv Series Tracker sometime soon? 🙂
@@clairisaphoinix23 I do have a movie tracker tutorial if you check on my channel, you could use that for tv series too
@@creative_cove That's a great idea thank you 🙂
Ps. I was able to connect this database to my task database so I can put the time with the overarching task. Wasn’t hard to do but I hadn’t ever done it before. So now I can see what projects take up what time 🎉
That's awesome!
Thank you Siiss
You're welcome!
I love you
This is really helpful, thank you! I am wondering if you can add a "Pause" button as well, to automatically stop and restart the time tracker for the project? Is this possible?
It would be difficult to add a pause button using this system so the easiest way is probably just stopping the session and re-starting a new one :)
Hi! Thanks so much for the tutorial! But I womder how I can use it if I already have my tasks database? I would like to see how many hours worked total in ALL tasks. Is it possible?
Do you know how can I connect this to an already existing task database? I would like it when the button starts it automatically adds the task name related to the task itself. that way I don't have to add a task name to the task I'm already working on. I just want to track the time spent on it , thanks
I noticed the calculation for the total time for the task is off. I don;t know how to fix it but its the same what you input. Its always off by a couple minutes. Do. you know a fix?
I think that would be due to the rounding as we have rounded it down to 2 decimal points. If you want to remove the rounding to give the most accurate number just remove the round() function we added or change the number from 100 inside the formula to 1000 for 3 decimal points.
@@creative_cove I just tried... It's so weird because every input, it's adding random amount of min onto the total