SecondsAfter

Description

Gets the number of seconds one time occurs after another.

Syntax

SecondsAfter ( time1, time2 )

Argument

Description

time1

A time value that is the start time of the interval being measured

time2

A time value that is the end time of the interval

Returns

Long. Returns the number of seconds time2 occurs after time1. If time2 occurs before time1, SecondsAfter returns a negative number.

Examples

Example 1

This expression returns 15:

SecondsAfter(21:15:30, 21:15:45)

Example 2

This expression returns -15:

SecondsAfter(21:15:45, 21:15:30)

Example 3

This expression returns 0:

SecondsAfter(21:15:45, 21:15:45)

See also