Calculates a time value by adding hours to (or subtracting hours from) a specified time value.
$addhours(time,number)
where
time | an 8-digit number, or an expression that evaluates to an 8-digit number, that expresses a valid time value in the format HHMMSSTT |
number | a number, or an expression that evaluates to a number |
Number, representing a time value.
Use $addhours to perform arithmetic with time values. The $addhours function calculates a time value by adding a number representing hours to a time value. If number is negative, the effect is to subtract the hours from the time.
If $Time has the value 22503075, then
$addhours($time,1)
Evaluates to 23503075.
$addhours($time,2)
Evaluates to 00503075.
$addhours($time,-3)
Evaluates to 19503075.