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 (DateTime)
Date with time to which seconds can be added.
utc (UTC)
Date with time in UTC format to which seconds can be added.
number (Number)
A number of whole and fractional seconds. The value parameter can be negative or positive.
Returned type:
DateTime | DateTime(UTC)
examples:
=addseconds(date(1999, 1, 1),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