In a column of type formula, the function HOUR_DELTA () makes it possible to make a subtraction between two columns of type date and hour to display the result in hour:
HOUR_DELTA = time1 - time2
Formula
HOUR_DELTA (moment1, moment2)
Example
HOUR_DELTA (End, Start)
There is a gap of 3 hours between the End column and the Start column.
Comments
0 comments
Please sign in to leave a comment.