Question

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

Answer 1

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.