In a formula-type column, the TIME_DELTA() function calculates the difference, in minutes, between two date and time-type columns.
-
Function name:
TIME_DELTA()
Syntax
TIME_DELTA(moment_1, moment_2)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
moment_1 |
The most recent moment (the result corresponds to moment_1 minus moment_2). |
moment_2 |
The reference moment to subtract. |
Example
TIME_DELTA($End, $Start)
The column returns the number of minutes difference between the two dates and times.
There is a 5 minute difference between the End column and the Start column.
Return Type
The function returns a number (the difference expressed in minutes).
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business Use Case
TIME_DELTA() measures a precise duration in minutes: intervention time, meeting duration, processing time.
Best Practice
Both columns must include the time. For a result in hours rather than minutes, use HOUR_DELTA().