Difference between revisions of "ELAPTIME()"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
(See Also)
 
(5 intermediate revisions by 2 users not shown)
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()]], [[SET CLOCK]], [[SET CLOCKRATE]], [[TIME()]], [[TSTRING()]], [[VALIDTIME()]]
+
[[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOA()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOT()]], [[DTOV()]], [[EMPTY()]], [[EPOCH()]], [[GOMONTH()]], [[HOUR()]], [[HOURS()]], [[ISLEAPYEAR()]], [[LEAPYEARS()]], [[LTOS()]], [[MDY()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[MTOD()]], [[MTOS()]], [[QUARTER()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[SET SECONDS]], [[STOD()]], [[STOT()]], [[STR()]], [[STRFTIME()]], [[TIME]], [[TIME()]], [[TIMEOFDAY()]], [[TIMESTAMP()]], [[TSTRING()]], [[TTOC()]], [[TTOD()]], [[TYPE()]], [[VAL()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]]
 
+
  
 
==Description==
 
==Description==
The ELAPTIME() function returns a time string in the form "HH:MM:SS" which is the difference between <timestring2> and <timestring1>. This function can be very useful when used in the Application Data Dictionary to define a total work time field.
+
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>
  
 
==Products==
 
Recital Server, Recital
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Date and Time Data]]
 
 
[[Category:Date and Time Data Functions]]
 
[[Category:Date and Time Data Functions]]
 +
[[Category:Lianja VFP Extensions]]
 +
[[Category:VFP Function Extensions]]

Latest revision as of 07:10, 16 November 2020

Purpose

Function to return time difference between two time strings

Syntax

ELAPTIME(<timestring1>,<timestring2>)

See Also

AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOA(), DTOC(), DTOM(), DTOS(), DTOT(), DTOV(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), LEAPYEARS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), STOT(), STR(), STRFTIME(), TIME, TIME(), TIMEOFDAY(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()

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