Macro for calculation of Service Cost

Hi,

Need your assistance on the following:

In the file attached, I have a dump data sheet which have two columns Site ID & Duration of outage (minutes) marked in Grey cells.

I have this dump data for about 11 states and would like to automate the calculation of same through some kind of macro.

There is a penalty if uptime is less than 100%.
Uptime calculation is number of minutes in a month - Duration of outage (minutes)

Eg: for Site ID: AKRA58, total outage minutes are 115+32=147, therefore uptime is =100%-(147/43200)=99.66% (24 hours*60 minutes*30 Days)

This calls for a penalty of 10% on Service Charges as it falls in the penalty bracket of (99.70-99.50), taken from penalty sheet.

I would to represent the data as in "Result tab". All cells marked in light yellow is what I am looking to get through a Macro. I will manage the service charges.

Hope to have a response from you on this.

regards,

Hi,

One change is required in the replied file. In Uptime calculation, we were using 24hours*60minutes*30days...we need to calculate this for 31 days instead of 30 days...

what need to be done to incorporate this change...

Looking forward to your reply...