TIME_DELTA() : calculate a gap in minutes between two times

In a formula column, the TIME_DELTA() function calculates the gap, in minutes, between two date and time columns. The result is a number.

The key point: both columns must include time. Without the Time option enabled on both columns, TIME_DELTA() cannot calculate a gap in minutes.

Syntax

TIME_DELTA(moment_1, moment_2)

# Parameter Description

1 moment_1 The most recent moment (the result is moment_1 minus moment_2).

2 moment_2 The reference moment to subtract.

The column returns the number of minutes between the two dates and times.

TIME_DELTA($End, $Start)

There is a 5 minute gap between the End column and the Start column.

One of the columns does not include time

Enable the Time option on both source columns so TIME_DELTA() can calculate the gap in minutes.

The column output format is not Number

In the Options tab, set the output format to Number. For details, see Output format options in the Formula column article.

For a result in hours rather than minutes.

Read more →

All available operators and functions, sorted by category.

Read more →