Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to remove seconds in TIME() & subtract it.........
Message
 
To
02/08/2004 07:08:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00930059
Message ID:
00931702
Views:
25
Hi Mohammed,

If you haven't done this, try this..

Not sure what is the value of "thisform.text3.value"
>thisform.text1.value-thisform.text2.value=thisform.text3.value
>thisform.text4.value-thisform.text5.value=thisform.text6.value
>at thisform.text7.value=(thisform.text3.value+thisform.text6.value)*($11.90)

Below is a sample of Subtracting Time from two text boxes...get the spent time & multiply with a pre-defined rate...
STORE TTOC(CTOT(thisform.text2.value)-CTOT(thisform.text1.value)+{^2000/01/01:},2) TO tTime_spent 
Thisform.txtTime_spent.Value = SUBSTR(tTime_spent,1,5)

STORE SUBSTR(Thisform.txtTime_spent.Value,1,2) TO thour
STORE SUBSTR(Thisform.txtTime_spent.Value,4,2) TO tMinute
nTime= tHour+"."+tMinute
ybill_charge = Val(nTime) * yEmp_rate
Jojo R. dela Cuesta, B.Sc.
eConsultant, Programmer
Dalplus Technologies
http://www.dalplus.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform