How to Build a Timesheet in Notion | TEMPLATE INCLUDED
HTML-код
- Опубликовано: 7 сен 2024
- Notion Timesheet Template: ty-teaches-tec...
Formula for 'Work Hours' Property:
round((dateBetween(prop("End"), prop("Start"), "minutes") - 60 * prop("Break Hours")) / 60 * 100) / 100
Follow for more: taplink.cc/tyl...
In this tutorial I teach you how to build a dynamic timesheet in Notion utilizing the buttons, databases, and formulas. Let me know if you have any questions!
More from notion Notion: notion.so
This will help me track my coding sessions as I learn how to code. Thanks
The Clock In Clock Out buttons are so much better than what I was doing. Almost the same build, but I was using the DateStarted and Last Edited to grab my times…. Wish I new about the “now” function in the buttons before! Happy to know about it now, this is beautiful!
Thank you so much! I try to assume the simplest way exists first and work my way to more cumbersome approaches from there. That’s how I stumbled upon that “now” function
Legend! I was looking for exaclty this... appreciate it
Excellent tutorial! Used it to log my volunteer hours.
that melts my heart it's going to a good cause. I need to volunteer more
Best Time sheet on Notion. Thanks
Brilliant, don’t know why I never thought of using buttons 👏🏼
Perfect time sheet. Thanks
Nice! Pretty useful indeed for freelancers! Thank you so much!
You got it:) appreciate your appreciation
This is AMAZING! Thank you!!
You’re very welcome!
Hi! Great video:) I was wondering how you would edit this to make sections for bi-weekly instead of weekly (like 1st-15th and 16th-30th)
It was useful. Served my purpose. Thank you :)
Nice video 🎉🎉🔥 thanks for this it was helpful ✨✨👍🏻
Appreciate it! More to come
This is so great and helpful :D
Aw thank you!
How can I use this template? This is going to be life saver.
what about a button with the option to pause? or does retapping clock in pause it automatically?
How can i use pause button? like i want to pause the time for sometime and start from there again
HI, this is great but I get an extra field when creating the 'edit pages' in the clock out button. It adds 'start date' next to 'start'. How do I remedy this? Many thanks.
I am completely new to notion, the formula was a struggle but I figured it out. the clock out filter is where I'm stuck is is for "empty" in the drop down menu like yours :( someone help
Hey! You can hit me up on ig @tyteachestech w a pic and I can help you
Did we get an answer to this? Im having the same issue @@tyteachestech
Thank you!
You’re welcome! Hope it helped
Thanks so much for the tutorial, can I ask how did you move the clock out button to the right on the same line?
Ahh yes that’s a tricky one. My other Notion video shows you towards the end
AMAZING!!!!!!!!!!!!!!!!!
Awesome.
how can i change week start day for example i wanna be Saturday to be start of the week
To change the week start day in Notion, you can follow these steps:
1. Open Notion and go to the desired page or workspace.
2. Click on the three-dot menu icon located at the top right corner of the page.
3. Select "Settings & Members" from the dropdown menu.
4. In the "Settings" section, find the "Week Start Day" option.
5. Click on the current day (usually set as Sunday by default) to open the dropdown menu.
6. Choose your preferred day to set it as the new week start day.
7. The changes will be applied automatically, and the calendar and date-related features in Notion will now consider the selected day as the start of the week.
Note that changing the week start day affects the display and calculation of dates in Notion, and it's a workspace-wide setting that will be consistent for all pages within that workspace.
can you tell me how to change the timezone? thank you
Sure! Head to Notion Settings → My Settings (2nd Option) → Time Zone (towards the middle). You can also do it straight from a Date Property by clicking a random field in the column → Date format & timezone → Timezone
Is anyone else having the problem of not being able to duplicate to create more months? will it update automatically?
Can I change the break time format? For example, if you input a number in the cell it will convert and show
"1 hr, 43 min" automatically.
prop("Time in Minutes") / 60 + " hr, " + prop("Time in Minutes") % 60 + " min"
Is this the same formula for the the 'work hours'?@@tyteachestech
Bro youre literally Austin witsit of notion from witsit gets it channel
he sounds awesome
this is brilliant, thank you😲
of course :) I got your back
How would I add my hourly pay into this?
If you’re hourly rate is consistent you can make a column that’s a formula type and have it multiply the time worked by the rate and the sum of that will be what you’re owed
@@tyteachestech Thanks so much!
@@tyteachestech how would you write that formula please I'm struggling?