#!/bin/awk BEGIN{printf "%s\t\t%s\t%s\n", "USER", "LOGINS", "TIME"} #{print $0} { if (match($0,"/[0-9]\+[0-9]/")!=1) { split($10, day, "+") dy=substr(day[1],2,1) #print dy; minutes+=dy*1440 #print min } } { if (match($0,/"[0-9][0-9]:[0-9][0-9]\)"/)!=1) { split($10, time, ":") min=substr(time[2],0,2) hr=substr(time[1],2,2) minutes+=min+(hr*60) #print min,hr #print min } } {array[$1]++;} {time[$1]=minutes;} { #print time[$1] minutes=0 } END{ for (i in array) { D=int((time[i]/1440)); time[i]-=(1440*D); H=int((time[i]/60)); time[i]-=(60*H); M=int((time[i]/60)); time[i]-=(60*M); printf "%-10s\t%-10s\t%-10s\n", i, array[i], time[i]; } }