>hi all,
>i try to sum this hours and minuts via this code under , it sum hours ok,
>somthing rong with minuts
>ex:34:20+36:40+71:10+66:10 the result must be 208:20
>
>via this code under i get 208:44
>
> SUM VAL(LEFT(m1_m,8))*3600 + ;
> VAL(SUBSTR(m1_m,6,2))*30 + ;
> VAL(RIGHT(m1_m,2)) TO lnSec
> m.dae= PADL(INT(lnSec/3600), 6, "0") + ":" + ;
> PADL(INT((lnSec%3600)/60),2, "0")
>
>thanks.
I see a typo in your formula, change 30 to 60! 60 is for 60 minutes in an hour, 30 means nothing.