In a formula column, the DATEHOUR_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 hours.
Formula
DATEHOUR_ADD(Colonne date, Nombre X)
Or
DATEHOUR_ADD(Colonne date, Colonne heure)
The first parameter is the exact name of a date column.
The second parameter is either :
- An integer that corresponds to the number of hours I want to add. This number can be positive or negative.
- The exact name of a column of type integer.
Example
DATEHOUR_ADD(Début,{Durée (heures)})
Configurator
Result
The end date is the sum of the start date and the duration.
Comments
0 comments
Please sign in to leave a comment.