Scripting Help needed.

[pinga123]

Following is a output of command which shows cpu% of ABC machine (15 minute interval).

Host CPU% time
ABC  50.55 14 : 15
ABC  50.25 14 : 15
ABC  50.1 14 : 15
ABC  50.45 14 : 30
ABC  50.25 14 : 30

I would like to take above file as input .
Notice that for every 15 minuate interval there are some entries generated.
for example : for 14:15 there are 3 entries .
for 14:30 there are 2 entries.

I would like to get average of cpu% considering time.
say.

ABC  50.3 14 : 15
ABC  50.33 14 : 30

How would i achieve this?

[Kloschüssel]

Take a look at awk.