VB code to calculate loading on equipment per Product

Hi.

I have a bit complicated question (yet not sure if excel vba is the right tool or better to work with SAS).

I have a list of machines with a time stamp for each time they are performing activity.

i.e.

07/31/2016 00:12:11 Machine-A Cup
07/31/2016 00:12:21 Machine-A Dish
07/31/2016 00:12:31 Machine-A Spoon
07/31/2016 00:12:41 Machine-A Cup
07/31/2016 00:12:51 Machine-A Cup
07/31/2016 00:14:11 Machine-A Knife

What I need is to add for each line few columns with how loaded the equipment was before this activity in the last hour.

i.e.
Time Eqp Prod Cup Dish Spoon
07/31/2016 00:12:11 Machine-A Cup 3 7 9

Any Idea?

Thank you.