AddMinutes

Description of formula: 
Returns date with time which is a product of adding minutes to a chosen date with time.
Syntax:
ADDMINUTES(datetime|utc,number)

Parameters:

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(2026, 1, 1,2,20,00),90)
=addminutes(Section1.A1,20)
=addminutes(A,-15) 
=addminutes(B3, C1+3)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk