Question
June 13, 2007 at 01:46 AM
andrew.smith

Percentages Formulas

by andrew.smith . Updated 19 years, 2 months ago

http://img257.imageshack.us/img257/7738/excelll8.png

Ok, not sure how to explain this properly so here goes;

If you look at that screendump you will see the Days, and then Plant 1,2,3 and the last column showing “% of uptime”.

I need to find the percentage of uptime for each particular Plant per week, if there is 480 minutes in the full daily shift.

Example, Plant 2 shows WEEK TOTAL of 28, so I need to find the weekly percentage, and there is 480mins per day.

Could you help?

thx

This discussion is locked

All Comments