rendered paste body#!/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];
}
}