select cname, ; sum(3600*val(subs(ctime,1,2)) + ; 60*val(subs(ctime,4,2)) + ; val(subs(ctime,7,2))) as nsec ; from theFile ; group by cname ; into cursor q1Get time formated as the original string:
select cname, ; nsec, ; str(int(nsec/3600),3) + ':' + ; str(int(mod(nsec,3600)/60),2) + "'" + ; str(mod(nsec,60),2) as ctime ; from q1 ; into cursor q2Get time formated as hours, min, sec:
select cname, ; nsec, ; int(nsec/3600) as nhours, ; int((mod(nsec,3600)/60)) as nmin, ; int(mod(nsec,60)) as ctime ; from q1 ; into cursor q2