问个时分秒计算的程序

huang6894

hi，all：

1. 1806700                 huang6894             wait time/0:0:0:3（依次是日：时：分：秒）       run time/0:0:0:7        maxvmem/256.219M
   
2. 1806799                 huang6894              wait time/0:0:0:4       run time/0:0:0:7        maxvmem/256.699M
   
3. 1806699                 huang6894             wait time/0:0:0:3       run time/0:1:53:26      maxvmem/450.352M
   
4. 1816637                 huang6895              wait time/0:0:0:3       run time/0:0:59:5       maxvmem/217.535M
   
5. 1835283                 huang6895              wait time/0:0:12:16     run time/0:0:6:58       maxvmem/368.121M
   
6. 1817872                 huang6896            wait time/0:0:0:4       run time/0:7:36:23      maxvmem/709.000M
   
7. 1836650                 huang6896             wait time/0:0:0:21      run time/0:8:33:15      maxvmem/262.008M
   
8. 1861096                 huang6897             wait time/0:0:0:5       run time/0:0:11:8       maxvmem/9.457G
   

复制代码

我想对对应第二列的第三第四第五列求和，应该怎么做啊？
想得到：

1. 1806700                 huang6894             wait time/0:0:0:3       run time/0:0:0:7        maxvmem/256.219M
   
2. 1806799                 huang6894              wait time/0:0:0:4       run time/0:0:0:7        maxvmem/256.699M
   
3. 1806699                 huang6894             wait time/0:0:0:3       run time/0:1:53:26      maxvmem/450.352M
   
4. 1816637                 huang6895              wait time/0:0:0:3       run time/0:0:59:5       maxvmem/217.535M
   
5. 1835283                 huang6895              wait time/0:0:12:16     run time/0:0:6:58       maxvmem/368.121M
   
6. 1817872                 huang6896           wait time/0:0:0:4       run time/0:7:36:23      maxvmem/709.000M
   
7. 1836650                 huang6896             wait time/0:0:0:21      run time/0:8:33:15      maxvmem/262.008M
   
8. 1861096                 huang6897             wait time/0:0:0:5       run time/0:0:11:8       maxvmem/9.457G
   
9. 
   
10. ===>count all：
    
11. huang6894             wait time:0:0:0:10       run time:0:1:53:40        maxvmem:963.270M
    
12. huang6895             wait time:0:0:12:19       run time:0:1:6:3        maxvmem:585.656M
    
13. huang6896             wait time:0:0:0:25       run time:0:16:9:38        maxvmem:971.008M
    
14. huang6897             wait time:0:0:0:5       run time:0:0:11:8       maxvmem:9.457G
    

复制代码

li0924

给你部分代码，你自己在完整下。结果如下：

1. linux-v2d9 px1/lottu> awk -f lottu.awk lottu19
   
2. huang6894 0:0:0:10 0:1:53:40
   
3. huang6895 0:0:12:19 0:1:6:3
   
4. huang6896 0:0:0:25 0:16:9:38
   
5. huang6897 0:0:0:5 0:0:11:8

复制代码

部分代码如下

1. function ttos(t){split(t,a,":");s=a[1]*86400+a[2]*3600+a[3]*60+a[4];return s}
   
2. function stot(s){d=int(s/86400);h=int(s%86400/3600);m=int((s-d*86400-h*3600)/60);se=int(s%60);f=sprintf("%d:%d:%d:%d",d,h,m,se);return f}
   
3. 
   
4. BEGIN{FS="[ /]+"}{arr[$2]+=ttos($5);brr[$2]+=ttos($8);}END{for(i in arr){print i,stot(arr[i]),stot(brr[i])}}

复制代码

huang6894

回复 2# li0924


    大神。。。你太逗了吧

li0924

回复 3# huang6894
?; 是没给完整代码吗？
本来是可以给你的，我被自己坑了，函数stot里面开始返回为i;后来改为f。导致brr；返回不了结果。现在我下班了，你忙去吧

   

huang6894

回复 4# li0924


    哈哈，谢谢你。。。我还以为你专门弄了个表情在代码中间逗我玩呢，哈哈

jason680

回复 1# huang6894

here you are

$ awk -F'  +|/' 'BEGIN{K=1000;a[4]=a[3]=60;a[2]=24}function add(){for(n=4;n<=8;n+=2)if(n==8){if(sub("G$","",S[n]))S[n]*=1000;if(sub("G$","",$n))$n*=K;S[n]+=$n;S[n]=(S[n]>=K)?S[n]/K"G":S[n]"M"}else{split(S[n],s,":");S[n]="";split($n,t,":");for(c=4;c>0;c--){s[c]+=t[c];if(s[c]>a[c]&&a[c]!=""){s[c-1]+=int(s[c]/a[c]);s[c]%=a[c]};r=c==4?"":":";S[n]=sprintf("%02d%s",s[c],r""S[n])}}}function P(){printf("%-12s%-24s%-24s%-s\n",N,$3":"S[4],$5":"S[6],$7":"S[8]);delete S;delete s}N!=$2{if(N!="")P()}{add();N=$2;}END{P()}' FILE
huang6894   wait time:00:00:00:10   run time:00:01:53:40    maxvmem:963.27M
huang6895   wait time:00:00:12:19   run time:00:01:06:03    maxvmem:585.656M
huang6896   wait time:00:00:00:25   run time:00:16:09:38    maxvmem:971.008M
huang6897   wait time:00:00:00:05   run time:00:00:11:08    maxvmem:9.457G

huang6894

回复 6# jason680


    很感谢你，谢谢，谢谢

li0924

回复 4# li0924

1. function ttos(t){split(t,a,":");s=a[1]*86400+a[2]*3600+a[3]*60+a[4];return s}
   
2. function stot(s){d=int(s/86400);h=int(s%86400/3600);m=int(s%3600/60);se=int(s%60);f=sprintf("%d:%d:%d:%d",d,h,m,se);return f}
   
3. BEGIN{FS="[ /]+"}
   
4.      {wait[$2]+=ttos($5);
   
5.      run[$2]+=ttos($8);
   
6.      mem[$2]+=/G/?$10*1024:$10}
   
7.      END{for(i in wait){
   
8.      print i,"wait time:"stot(wait[i]),"run time:"stot(run[i]),"maxvmem:"(int(mem[i]/1024)?mem[i]/1024 "G":mem[i]"M")}
   
9.      }

复制代码

测试

1. lottu> awk -f lottu.awk lottu19|column -t
   
2. huang6894  wait  time:0:0:0:10   run  time:0:1:53:40  maxvmem:963.27M
   
3. huang6895  wait  time:0:0:12:19  run  time:0:1:6:3    maxvmem:585.656M
   
4. huang6896  wait  time:0:0:0:25   run  time:0:16:9:38  maxvmem:971.008M
   
5. huang6897  wait  time:0:0:0:5    run  time:0:0:11:8   maxvmem:9.457G

复制代码

yestreenstars

1. #!/bin/awk -f
   
2. function A(a){split(a,f,"[/:]");return f[2]*86400+f[3]*3600+f[4]*60+f[5]}
   
3. function B(b){return int(b/86400)":"int(b%86400/3600)":"int(b%3600/60)":"int(b%60)}
   
4. function C(c){match(c,/([^/]+)(.)$/,g);if(g[2]=="G")g[1]*=1024;return g[1]}
   
5. function D(d){if(d/1024>1)return d/1024"G";else return d"M"}
   
6. {w[$2]+=A($4);r[$2]+=A($6);m[$2]+=C($7)}
   
7. END{for(i in w)printf "%s\twait time:%s\trun time:%s\tmaxvmem:%s\n",i,B(w[i]),B(r[i]),D(m[i])}

复制代码

result:

1. huang6894       wait time:0:0:0:10      run time:0:1:53:40      maxvmem:963.27M
   
2. huang6895       wait time:0:0:12:19     run time:0:1:6:3        maxvmem:585.656M
   
3. huang6896       wait time:0:0:0:25      run time:0:16:9:38      maxvmem:971.008M
   
4. huang6897       wait time:0:0:0:5       run time:0:0:11:8       maxvmem:9.457G

复制代码

li0924

回复 9# yestreenstars
看了你的代码，我才理解

1. int(b%86400%3600/60)":"int(b%86400%3600%60)

复制代码

可以简化为

1. int(b%3600/60)":"int(b%60)

复制代码