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


Return value

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

Examples

This expression returns 15:

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

This expression returns -15:

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

This expression returns 0:

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

See also

DaysAfter