DATEHOUR_ADD() : add hours to a date and time

In a formula column, the DATEHOUR_ADD() function displays a date and time obtained by adding a number of hours to a date and time column. The result is a date and time.

The key point: the source column must include time. If the Time option is not enabled on the date column, DATEHOUR_ADD() has no time to shift.

Syntax

DATEHOUR_ADD(date_column, number_of_hours)

Parameters

# Parameter Description

1 date_column The date and time column to add hours to.

2 number_of_hours The whole number of hours to add. Positive to move forward, negative to move back.

Examples

Shift a date and time by 5 hours

The column returns the date and time shifted by 5 hours.

DATEHOUR_ADD($Date, 5)

DATEHOUR_ADD shifting a date and time by 5 hours

Your formula returns 0 or stays empty

The source column does not include time

Enable the Time option on the source date column so DATEHOUR_ADD() has an hour to shift.

The column output format is not Date

In the Options tab, set the output format to Date and enable time. For details, see Output format options in the Formula column article.

Go further

DATEMINUTE_ADD

For an offset expressed in minutes rather than hours.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.