Calculating Total Time in one sheet and pasting the results automatically in another sheet

[hsshah]

I have an excel workbook which requires us to enter the log details of some sites and then a report is generated using these logs (report attached) TinyUpload.com - best file hosting solution, with no limits, totaly free (Sorry guys I didn't know how to paste so much data in a single post. Kindly bear with this link.)


I want that excel should automatically identify the site and calculate its outage with the following formula:

Outage %age= Total Outage(min)/100.80
and add it in the respective column while identifying the outage.

e.g. if outage is of power then the calculated %age outage should be pasted in the power outage column in front of the respected site.

e.g. in the sheet attached above the first row in the first sheet states that SKU2326 was down for 50 mins

Now %age outage will be
Outage %age= 50/100.80
Outage %age=0.496

Now as the outage is related to power so this outage should go into power column in sheet number 3 labelled as "Network Total Up time Week#17"

Now the next time SKU2326 becomes down it should be added with this 50 mins and the outage calculated as presented above.

So guys I know it's a lot to ask but kindly help is needed. All help will be appreciated.

Thanks in advance.

 

[hsshah]

Any luck ???