[Excel] linux time result calulate May 23, 2017 B5: real+user+sys B5: =(LEFT(B2,FIND("m",B2)-1)*60+MID(B2, FIND("m",B2)+1,5))+(LEFT(B3,FIND("m",B3)-1)*60+MID(B3, FIND("m",B3)+1,5))+(LEFT(B4,FIND("m",B4)-1)*60+MID(B4, FIND("m",B4)+1,5)) Read more
[linux/bash script] time command result sum March 27, 2017 calc_alltime.sh #!/bin/bash TIME_RESULT_FILE=${1} if [ "${TIME_RESULT_FILE}" != "" ]; then if [ -f ${TIME_RESULT_FILE} ]; then egrep "^[rus]" ${TIME_RESULT_FILE} |awk ' { print $2 } '| sed -e 's/m/ /'g |sed -e 's/s$//g' | awk ' { SUM_MIN=SUM_MIN+$1; SUM_SEC=SUM_SEC+$2; } END { NEW_MIN=int(SUM_SEC/60); SUM_MIN=SUM_MIN+NEW_MIN; SUM_SEC=SUM_SEC-(NEW_MIN*60); print SUM_MIN "m" SUM_SEC "s" } ' else echo "File not exist" fi fi example of FILE # cat tt 1th try real 0m2.564s user 0m0.032s sys 0m0.033s 2th try real 0m2.586s user 0m0.039s sys 0m0.034s 3th try real 0m2.810s user 0m0.036s sys 0m0.042s 4th try real 0m3.155s user 0m0.042s sys 0m0.040s # calc_alltime.sh tt 0m11.413s Read more