ELAPTIME()

From Lianjapedia
Revision as of 07:21, 10 December 2012 by Admin (Talk | contribs)

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
Retrieved from "https://www.lianja.com/doc/index.php?title=ELAPTIME()&oldid=5624"