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