Skip to main content

Search

Let us guide you!

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

Updated on

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)

Parameters

# 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.

Examples

Calculate a gap in minutes

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

TIME_DELTA($End, $Start)
TIME_DELTA calculating a 5-minute gap between End and Start

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

Your formula returns 0 or stays empty

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.

Go further

HOUR_DELTA

For a result in hours rather than minutes.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.

Read more →