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

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)

# 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 hours between the two dates and times.

HOUR_DELTA($End, $Start)

There is a 3 hour 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 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.

For minute-level precision rather than hours.

Read more →

All available operators and functions, sorted by category.

Read more →