FT_ACCTADJ() Adjust beginning or ending fiscal pd. dates to acctg. dates FT_ACCTMONTH() Return accounting month data FT_ACCTQTR() Return accounting quarter data FT_ACCTWEEK() Return accounting week data FT_ACCTYEAR() Return accounting year data FT_ADDWKDY() Return true number of days to add given number of workdays FT_CALENDAR() Display date/time calendar, find a date, return calendar data. FT_CIV2MIL() Convert usual civilian format time to military time. FT_DATECNFG() Set beginning of year/week for FT_ date functions FT_DAYOFYR() Return calendar, fiscal or accounting day data FT_DAYTOBOW() Calculate no. of days between date and beginning of week FT_DOY() Find number of day within year FT_EASTER() Return the date of Easter FT_ELAPMIN() Return difference, in minutes, between two mil format times. FT_ELAPSED() Return elapsed time between two days and/or times FT_ELTIME() Compute difference between times in hours, minutes, seconds. FT_FDAY() Return first day of the month FT_LDAY() Return last day of the month FT_MADD() Add or subtract months to/from a date FT_MIL2CIV() Convert time in military format to civilian format. FT_MIL2MIN() Convert time in military format to number of minute of day. FT_MIN2DHM() Convert numeric minutes to days, hours and minutes. FT_MIN2MIL() Convert minute of day to military format time. FT_MONTH() Return Calendar or Fiscal Month Data FT_QTR() Return Calendar or Fiscal Quarter Data. FT_SYS2MIL() Convert system time to military time format. FT_WEEK() Return calendar or fiscal week data FT_WORKDAYS() Return number of work days between two dates FT_WOY() Find number of week within year FT_YEAR() Return calendar or fiscal year data
Tag Archives: FT_ELTIME()
FT_ELTIME
FT_ELTIME()
Compute difference between times in hours, minutes, seconds.
Syntax
FT_ELTIME( <cTime1>, <cTime2> ) -> cDiff
Arguments
<cTime1, cTime2> character strings representing times in
hh:mm:ss format.
Returns
<cDiff> character string representing time difference in
hh:mm:ss format.
Description
Return the absolute difference between two times in hh:mm:ss format
in character hours, minutes and seconds (hh:mm:ss).
Examples
FT_ELTIME( "22:40:12", "23:55:17" ) -> 01:15:05
FT_ELTIME( "23:55:17", "22:40:12" ) -> 01:15:05
Source: ELTIME.PRG
Author: Alexander B. Spencer
See Also: FT_ELAPMIN() FT_MIL2MIN() FT_MIN2MIL()
FT_ELAPSED
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
FT_ELAPMIN
FT_ELAPMIN()
Return difference, in minutes, between two mil format times.
Syntax
FT_ELAPMIN( <cTIME1>, <cTIME2> ) -> nMINUTES
Arguments
<cTIME1, cTIME2> character strings of military form "hhmm",
where 0<=hh<24.
Returns
<nMINUTES>
Description
Finds the arithmetic difference between time two times
(time 2 - time 1).
If time 2 is smaller than time 1, a NEGATIVE value is returned.
Examples
FT_ELAPMIN( "1718", "2040" ) -> 322
FT_ELAPMIN( "2040", "1718" ) -> -322
Source: ELAPMIL.PRG
Author: Alexander B. Spencer
See Also: FT_ELTIME() FT_MIL2MIN() FT_MIN2MIL()
