In a formula column, the DATEMINUTE_ADD() function is the addition of a date from a date column with the "time and date" option and a number X either constant or from an integer column that represents the number of minutes.
Formula
DATEMINUTE_ADD(Colonne date, Nombre X)
Or
DATEMINUTE_ADD(Colonne date, Colonne minutes)
The first parameter is the exact name of a date column.
The second parameter is either :
- An integer that corresponds to the number of minutes I want to add. This number can be positive or negative.
- The exact name of a column of type integer.
Example
DATEMINUTE_ADD(Début,{Durée (minutes)})
Configurator
Result
The end date is the sum of the start date and the duration.