AddHours

Description of formula:
Returns date with time which is a product of adding hours to a chosen date with time.
Syntax:
ADDHOURS(datetime|utc, number)
Parameters:
datetime (DateTime)
Date with time to which hours can be added.
utc (UTC)
Date with time in UTC format to which hours can be added.
number (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)
 
 
 
 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk