AddHours

Description of formula:
Returns a new DateTime that adds the specified number of hours to the value of this instance.
Syntax:
ADDHOURS(date, number)
Parameters:
date (Date)
An object whose value is the sum of the date and time represented by this instance and the number of hours represented by value.
number (Number)
A number of whole and fractional hours. The value parameter can be negative or positive.
Returned type:
Date
examples:
=addhours(date(1999, 1, 1),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