Notion – Find the number of seconds between two date/time fields (properties)

Are you setting up Notion templates with formulas for your team? Add this formula in one of our expert-created Notion templates.

See our Notion templates

Notion Formula: Find the number of seconds between two date/time fields (properties)

The formula is:

dateBetween(Furthest Away Date, Closest Date, amount, "seconds")

↑ Copy and paste into Notion then switch out the bold property name/s in the formula to match the name of the property name/s you’re using.

 

How to create a date formula in Notion

The steps to creating a date formula in Notion are:

  1. Create a Notion page
  2. Add a Notion database using the command /database (choose Database – Inline for this example)
  3. Add a column (property) by clicking on the + icon to the right of the existing column (property) name
  4. Select Date
  5. You can choose to add an extra date column (property) to set up a formula between the two properties or use a single column (property)
  6. Add another column (property) and scroll down to select Formula
  7. Click Edit next to the word Formula
  8. Add your formula in the grey box titled “Type a formula” and then click Done

 

How to edit a date formula in Notion

The steps to editing a date formula in Notion are:

  1. Click on the column (property) name and select Edit Property
  2. Click Edit next to the word Formula
  3. Edit your formula in the grey box and then click Done