Notion Answers

Get help from other 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

2votes

Hi,

Can someone please help me find a formula for calculating the number of minutes from a single date property that contains a start date with a time and an end date with time?

For instance, if the date is between June 8, 2021 10:00 - June 8, 2021 13:30, there are 3.5 hours between these times, so the formula would produce an outcome of 210; or, June 8, 2021 10:00 - June 9, 2021 13:30, there is 1 day and 3.5 hours or 27.5 hours between these times, so the formula would produce an outcome of 1650.

I am hoping to use this to calculate how much time I plan for a task minus how much time I actually spend working on a task.

Thanks in advance,
Jack

1 Answer

2votes

polle Points15930

Here is an example with "Start End" as property name for the dates.

format(dateBetween(end(prop("Start End")), start(prop("Start End")), "minutes")) + " minutes"

That will give you the complete minutes you have set in the "Start End" column with dates and time. Just replace "Start End" to match your column name.

Hope it helps.

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

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!

Connect