AddSeconds

Description of formula: 
Returns a new DateTime which is a result of adding seconds to a chosen date with time.

Syntax:
ADDSECONDS(datetime|utc, number)

Parameters:
datetime(type: dateTime)
 

Date with time to which seconds can be added.

utc(type:UTC)

Date with time in UTC format to which seconds can be added.

number(type:Number)

A number of whole and fractional seconds. The value parameter can be negative or positive.

Returned type:

DateTime | DateTime(UTC)

examples:
=addseconds(datetime(2026, 1, 1,10,1,00),1)

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

=addseconds(datetime(2026, 8, 2,10,40,5),120)

=addseconds(UTC(B3),25)