Skip to main content

Search

Let us guide you!

HOUR_DELTA() : add up hours (calculate a gap in hours)

Updated on

In a formula column, the HOUR_DELTA() function calculates the gap, in hours, 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, HOUR_DELTA() cannot calculate a gap in hours.

Syntax

HOUR_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 hours

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

HOUR_DELTA($End, $Start)
HOUR_DELTA calculating a 3-hour gap between End and Start

There is a 3 hour 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 HOUR_DELTA() can calculate the gap in hours.

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

TIME_DELTA

For minute-level precision rather than hours.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.

Read more →