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(1999, 1, 1,10,1,00),1)
=addseconds(Section1.A1,14)
=addseconds(A,-1)
=addseconds(B3, C1+3)
=addseconds(datetime(2014, 8, 2,10,40,5),120)
=addseconds(UTC(B3),25)
 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk