Calculates a time value by adding minutes to (or subtracting minutes from) a specified time value.
$addminutes(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 $addminutes to perform arithmetic with time values. The $addminutes function calculates a time value by adding a number representing minutes to a time value. If number is negative, the effect is to subtract the minutes from the time.
If $Time has the value 22503075, then
$addminutes($time,5)
Evaluates to 22553075.
$addminutes($time,10)
Evaluates to 23003075.
$addminutes($time,-5)
Evaluates to 22453075.
$addminutes($time,65)
Evaluates to 23553075.