Do you struggle with wasted time and wonder where your day goes? With Notion, you can track every minute and achievement easily and intelligently!

In a world full of distractions, knowing where your time goes and what you've accomplished is one of the biggest keys to productivity. In this step-by-step guide, I'll show you how to implement a successful time tracking system in Notion, inspired by the experience of Mostafa Yasser, an expert in digital productivity systems.

• Truly monitor your productive and wasted hours.
• Easily analyze your progress in any project or study with accurate, actionable data.
• Review your weekly or monthly performance to make better decisions on how to spend your time.

Add Start Time and End Time columns to your tasks or project database. These will be the foundation of your time tracking system.

Create two interactive buttons:

• A "Start" button that sets the task status to "In Progress" and records the current start time.
• An "End" button that marks it as "Done" and saves the end time.

Add a formula to automatically calculate the time difference between the start and end of each task:

Use the function:

dateBetween(End Time, Start Time, "minutes")

to instantly get the task duration in minutes—no manual calculation required.

Make your results clearer! Format your formula so the time unit ("minute," "minutes," "hour," or "day") changes automatically based on the duration. Use this smart formula for professional results:

if(
  empty(prop("End Time")),
  "",
  let(
    totalMinutes, dateBetween(prop("End Time"), prop("Start Time"), "minutes"),
    let(
      days, floor(totalMinutes / 1440),
      let(
        hours, floor((totalMinutes % 1440) / 60),
        let(
          minutes, totalMinutes % 60,
          if(days > 0,
            format(days) + " day" + if(days > 1, "s", "") +
            if(hours > 0, " and " + format(hours) + " hour" + if(hours > 1, "s", ""), ""),
            if(hours > 0,
              format(hours) + " hour" + if(hours > 1, "s", "") +
              if(minutes > 0, " and " + format(minutes) + " minute" + if(minutes > 1, "s", ""), ""),
              format(minutes) + " minute" + if(minutes > 1, "s", "")
            )
          )
        )
      )
    )
  )
)

• Name the columns exactly as shown in the example for the ready-made formula to work correctly.
• Review your work hours weekly and easily export detailed time reports from your database.
• Use the time tracking data to identify your most productive hours and optimize your schedule accordingly.