ELAPTIME()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return time difference between two time strings

Syntax

ELAPTIME(<timestring1>,<timestring2>)

See Also

AMPM(), DAYS(), HOURS(), MINUTES(), SECONDS(), SECS(), TIME(), TSTRING(), VALIDTIME()

Description

The ELAPTIME() function returns a time string in the form "HH:MM:SS" which is the difference between <timestring2> and <timestring1>.

Example

? elaptime("10:10:10","11:11:11")
01:01:01