Difference between revisions of "ELAPTIME()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return time difference between two time strings | Function to return time difference between two time strings | ||
− | |||
==Syntax== | ==Syntax== | ||
ELAPTIME(<timestring1>,<timestring2>) | ELAPTIME(<timestring1>,<timestring2>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AMPM()]], [[DAYS()]], [[HOURS()]], [[MINUTES()]], [[SECONDS()]], [[SECS() | + | [[AMPM()]], [[DAYS()]], [[HOURS()]], [[MINUTES()]], [[SECONDS()]], [[SECS()]], [[TIME()]], [[TSTRING()]], [[VALIDTIME()]] |
− | + | ||
==Description== | ==Description== | ||
− | The ELAPTIME() function returns a time string in the form "HH:MM:SS" which is the difference between <timestring2> and <timestring1>. | + | The ELAPTIME() function returns a time string in the form "HH:MM:SS" which is the difference between <timestring2> and <timestring1>. |
− | + | ||
==Example== | ==Example== | ||
Line 21: | Line 17: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Date and Time Data]] | [[Category:Date and Time Data]] | ||
[[Category:Date and Time Data Functions]] | [[Category:Date and Time Data Functions]] |
Revision as of 06:34, 10 February 2012
Contents
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