[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
FT_ELAPSED()
Return elapsed time between two days and/or times
------------------------------------------------------------------------------
Syntax
FT_ELAPSED([ <dStart> ], [ <dEnd> ], ;
<cTimeStart>, <cTimeEnd>) -> aTimedata
Arguments
<dStart> is any valid date in any date format. Defaults to DATE().
<dEnd> is any valid date in any date format. Defaults to DATE().
<cTimeStart> is a valid Time string of the format 'hh:mm:ss' where
hh is hours in 24-hour format.
<cTimeEnd> is a valid Time string of the format 'hh:mm:ss' where
hh is hours in 24-hour format.
Returns
A two-dimensional array containing elapsed time data.
Description
FT_ELAPSED() calculates the elapsed time between two Date/Time events.
It returns an array which contains the following data:
aRetVal[1,1] Integer Days aRetVal[1,2] Total Days (nn.nnnn)
aRetVal[2,1] Integer Hours aRetVal[2,2] Total Hours (nn.nnnn)
aRetVal[3,1] Integer Minutes aRetVal[3,2] Total Minutes (nn.nnnn)
aRetVal[4,1] Integer Seconds aRetVal[4,2] Total Seconds (nn)
Examples
FT_ELAPSED(CTOD('11/28/90'), CTOD('11/30/90'), '08:00:00', '12:10:30')
will return:
aRetVal[1,1] -> 2 (Days) aRetVal[1,2] -> 2.1740 Days
aRetVal[2,1] -> 4 (Hours) aRetVal[2,2] -> 52.1750 Hours
aRetVal[3,1] -> 10 (Minutes) aRetVal[3,2] -> 3130.5000 Minutes
aRetVal[4,1] -> 30 (Seconds) aRetVal[4,2] -> 187830 Seconds
Source: ELAPSED.PRG
Author: Jo W. French dba Practical Computing
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson