home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI482.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
1KB
|
67 lines
PRODUCT : PARADOX NUMBER : 482
VERSION : ALL
OS : PC DOS
DATE : September 11, 1991 PAGE : 1/1
TITLE : ILLUSTRATION OF THE MATCH FUNCTION
The following script illustrates the use of the MATCH function.
In this example, we would like to determine how many minutes have
elapsed between the start time and the end time. Additionally,
we would like to assign that value to the [Length of Call] field.
Also, military time should be used.
;TIME.SC
echo normal
EDIT "timetable" is the table being used
SCAN
x=MATCH([Start Time],"..:..:..",sh,sm,ss)
y=MATCH([End Time],"..:..:..",eh,em,es)
IF (x and y)
THEN startsec = numval(sh)*3600 + numval(sm)*60 + numval(ss)
endsec = numval(eh)*3600 + numval(em)*60 + numval(es)
[Length of Call] = round((endsec-startsec)/60,0)
ENDIF
ENDSCAN
DO_IT!