$addseconds

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

Syntax

$addseconds(time,number)

Parameters

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 $addseconds to perform arithmetic with time values. The $addseconds function calculates a time value by adding a number representing seconds to a time value. If number is negative, the effect is to subtract the seconds from the time.

Example

If $Time has the value 22503075, then

$addseconds($time,5)

evaluates to 22503575.

$addseconds($time,35)

evaluates to 22510575.

$addseconds($time,-5)

evaluates to 22502575.

$addseconds($time,65)

evaluates to 22513575.

$addseconds(22595900,1)

evaluates to 23000000.

 

Related Topics