AddHours

The formula adds a specified number of hours to the date.

Syntax	Description
ADDHOURS(DateTime, number)	Returns the datetime plus a specified number of hours.
ADDHOURS(UTC, number)	Returns the UTC date and time with a specified number of hours added.

---

ADDHOURS(Datetime, Number)

Returns the datetime with a specified number of hours added.

Syntax: addhours(DateTime, Number)

Name	Description
DateTime	type: Date | A date with a time to which a specified number of hours is added.
Number	type: Number | Number of hours to add. It can be positive or negative, and can be a whole number or a fraction.

Returns	Description
DateTime	DateTime(year, month, day, hour, minute, second, [milisecond])

Examples:

=addhours(datetime(2026, 1, 1,2,20,00),1)
=addhours(Section1.A1,14)
=addhours(A,-1) 
=addhours(B3, C1+3)

---

ADDHOURS(UTC, Number)

Returns the date and time UTC with a specified number of hours added.

Syntax: addhours(UTC, Number)

Name	Description
UTC	type: UTC | A date with a UTC time to which a specified number of hours is added.
Number	type: Number | Number of hours to add. It can be positive or negative, and can be a whole number or a fraction.

Returns	Description
UTC	UTC(year, month, day, hour, minute, second, [milisecond])

Example:

=addhours(Section1.A1,14)
=addhours(A,-1) 
=addhours(B3, C1+3)