Format Using Macro

Hello

After a lot of support from my friends and some geniuos people, my application is now in final stage.

Ok. Now my excel sheet has output like that i have attached.

Now i wanted to calculate the total of each group like X1,Y1 group.

Then I wanted to calculate effieciencyi.e effieciency = total time taken / user time taken

Please assist me to solve.