local lnSec10,lnSec11 SUM CTOT(plan) - CTOT("00:00:00") to lnSec * ? PADL(INT(lnSec/3600), 2, "0") + ":" + ; PADL(INT((lnSec%3600)/60),2, "0") + ":" + ; PADL(lnSec % 60,2, "0") SUM VAL(LEFT(plan,2))*3600 + ; VAL(SUBSTR(plan,4,2))*60 + ; VAL(RIGHT(plan,2)) TO lnSec lnSec10=lnSec THISFORM.TEXT10.VALUE= PADL(INT(lnSec/3600), 2, "0") + ":" + ; PADL(INT((lnSec%3600)/60),2, "0") * lnCost=thisform.text3.value *THISFORM.TEXT10.VALUE = ROUND(lnSec/3600*lnCost,2) SUM CTOT(true) - CTOT("00:00:00") to lnSec * ? PADL(INT(lnSec/3600), 2, "0") + ":" + ; PADL(INT((lnSec%3600)/60),2, "0") + ":" + ; PADL(lnSec % 60,2, "0") SUM VAL(LEFT(true,2))*3600 + ; VAL(SUBSTR(true,4,2))*60 + ; VAL(RIGHT(true,2)) TO lnSec lnSec11=lnSec THISFORM.TEXT11.VALUE= PADL(INT(lnSec/3600), 2, "0") + ":" + ; PADL(INT((lnSec%3600)/60),2, "0") thisform.text12.value=transform((lnSec11/lnSec10)*100)+'%'>hi all,
>SUM CTOT(plan) - CTOT("00:00:00") to lnSec >* ? PADL(INT(lnSec/3600), 2, "0") + ":" + ; > PADL(INT((lnSec%3600)/60),2, "0") + ":" + ; > PADL(lnSec % 60,2, "0") > >SUM VAL(LEFT(plan,2))*3600 + ; > VAL(SUBSTR(plan,4,2))*60 + ; > VAL(RIGHT(plan,2)) TO lnSec > >THISFORM.TEXT10.VALUE= PADL(INT(lnSec/3600), 2, "0") + ":" + ; > PADL(INT((lnSec%3600)/60),2, "0") > >* lnCost=thisform.text3.value >*THISFORM.TEXT10.VALUE = ROUND(lnSec/3600*lnCost,2) >SUM CTOT(true) - CTOT("00:00:00") to lnSec >* ? PADL(INT(lnSec/3600), 2, "0") + ":" + ; > PADL(INT((lnSec%3600)/60),2, "0") + ":" + ; > PADL(lnSec % 60,2, "0") > >SUM VAL(LEFT(true,2))*3600 + ; > VAL(SUBSTR(true,4,2))*60 + ; > VAL(RIGHT(true,2)) TO lnSec > >THISFORM.TEXT11.VALUE= PADL(INT(lnSec/3600), 2, "0") + ":" + ; > PADL(INT((lnSec%3600)/60),2, "0") >>thanks.