$addminutes

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

Syntax

$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

Return Value

Number, representing a time value.

Comments

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.

Example

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.

 

Related Topics