Description of formula:
Returns date with time which is a product of adding minutes to a chosen date with time.
Returns date with time which is a product of adding minutes to a chosen date with time.
Syntax:
ADDMINUTES(datetime|utc,number)
ADDMINUTES(datetime|utc,number)
Parameters:
datetime(type: dateTime)
datetime(type: dateTime)
Date with time to which minutes can be added.
utc(type:UTC)
Date with time in UTC format to which minutes can be added.
number(type:Number)
A number of whole and fractional minutes. The value of the parameter can be negative or positive.
Returned type:
DateTime | DateTime(UTC)
Examples:
=addminutes(datetime(1999, 1, 1,2,20),90)
=addminutes(Section1.A1,20)=addminutes(A,-15)
=addminutes(B3, C1+3)
0 Comments