$addhours

Calculates a time value by adding hours to (or subtracting hours from) a specified time value.

Syntax

$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

Return Value

Number, representing a time value.

Comments

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.

Example

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.