hi,
thank you for reply,
i try as under,but i get error result .the result is 15
but the data at myfield as under
rec1. tim= 10:30:15
rec2 = 12:30:15
rec3 = 18:00:10
rec4 = 10:10:30
i need the result as 51:11:10
thanks.
m.qasem
>You can reuse code from
Re: Calculate Time Message #
866527sum CTOT(tim) - CTOT("00:00:00") to lnSec
>lcTotalTime = PADL(INT(lnSec/3600), 2, "0") + ":" + ;
> PADL(INT((lnSec%3600)/60),2, "0") + ":" + ;
> PADL(lnSec % 60,2, "0")
>
>> i have at mytable field with time as under
>>rec1 field tim&&character type
>> 10:30:15
>>rec2 12:50:05
>>rec3 08:10:00
>>
>>i need to sum this field as
>>sum tim to m.k&&to get result 31:30:20
>>