r/Notion - How do I set a Date property with End date and Include time in a recurring template?

Property Schema

Property Type Description Value
Name Title The name of your event
Duration (min) Number How many minutes your event should last enter manually, could be in a page template
Created at Created Time used to determine what day the event should appear on n/a
Templated Time Date Used for its time (hours and minutes) When creating your template, choose the hour and minute you’d like your event to start at. The month, day, year will go unused
Start Formula Do a bunch of date math to add the appropriate hours and minutes of Templated Time to the date of Created at. =dateAdd(dateAdd(dateSubtract(dateSubtract(empty(prop("Date Override")) ? prop("Created at") : prop("Date Override"), minute(empty(prop("Date Override")) ? prop("Created at") : prop("Date Override")), "minutes"), hour(empty(prop("Date Override")) ? prop("Created at") : prop("Date Override")), "hours"), hour(prop("Templated Time")), "hours"), minute(prop("Templated Time")), "minutes")
End Formula Add Duration to the Start to determine the end of your event =dateAdd(prop("Start"), prop("Duration (min)"), "minutes")
Date Override Date Used to override the Created at property enter manually when you’d like to change the date an event appears at in your timeline

explained

That Start formula is a bit of a doozy. Expanded, it kind of looks like this:

dateAdd(
  dateAdd(
    // subtract time to remove the hours and minutes from the created time
    // basically gets you back to midnight
    dateSubtract(
      dateSubtract(prop("Created time"),minute(prop("Created time")),"minutes"),
      hour(prop("Created time")),
      "hours"
    ),
    // and then add the hours and minutes you assigned in the "Schedule" property
    hour(prop("Schedule")),
    "hours"
  ),
  minute(prop("Schedule")),
  "minutes"
)

The timeline will use separate start and end dates:

Untitled

And you can implement your weekly schedule by setting the templates to repeat as you might expect:

setting a “weekly” repeat will allow you to re-use the same template on multiple days. You’ll need separate events if you want them to appear at different times, though.

setting a “weekly” repeat will allow you to re-use the same template on multiple days. You’ll need separate events if you want them to appear at different times, though.

Prototype

agenda demo