Notion Answers

Help between Notion users

Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution



Question with datebetween Notion formula

I know how the Notion formula works. But when the date is the same and the time is different, this formula seems to not work properly. So what’s the right way to calculate this in Notion?

1 Answer


polle Points79930

If you want to count time rather than date in Notion, you should use the timestamp formula. The output of datebetween formula is "days", and minor data will be ignored. While the unit of the timestamp formula output is millisecond. 1000 millisecond = 1 second, it should be easier to transform it into any unit you want.

Hope that helps.


nosy commented

Thank you for explaining.

Please log in or register to answer this question.


Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!