Convert Percentage to total number of NPT Days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have for instance 31 days in March which has 8.75 days of NPT this
equals 1.18%, calculated using the following formula.
=IF(Total Days="","",(NPT Hours/(NPT Hours*24))*100) = 1.8%.

What if I only know ther percentage 1.8% and Number of Days in Month 31
days. How do I calculate this to get the number of days NPT?
 
I don't pretend to know what an NPT day or hour is and how they are arrived
at but the formula seems simple enough. If you substitute any value in place
of 'NPT Hours' the formula will return the result of 4.17 and not 1.8. For
example:-

=(8.75/(8.75*24))*100 = 4.17

Please clarify

Mike
 
Your formula makes no sense, as the

(NPT Hours/(NPT Hours*24))*100)

will always result in 4.166667 for non-zero NPT.


How are you really calculating your percentage?
 
Sorry my mistake

If I have for instance 31 days in March which has 8.75 hours of NPT this
equals 1.18%, calculated using the following formula.
=IF(Total Days March="","",(NPT Hrs/(Total Days March*24))*100) = 1.8%.

NPT = Non-Productive Time (downtime)

What if I only know ther percentage 1.8% and Number of Days in Month 31
days. How do I calculate this to get the number of days NPT?
 
Sorry I did this wrong first time, I hope the following is a bit clearer.

If I have for instance 31 days in March which has 8.75 hours of NPT this
equals 1.18%, calculated using the following formula.
=IF(Total Days March="","",(NPT Hrs/(Total Days March*24))*100) = 1.8%.

NPT = Non-Productive Time (downtime)

What if I only know ther percentage 1.8% and Number of Days in Month 31
days. How do I calculate this to get the number of days NPT?
 
What if I only know ther percentage 1.8% and Number of Days in Month 31
days. How do I calculate this to get the number of "hours NPT"?
 
to solve for NPT use 1.8%*31

Mike

Peledon said:
What if I only know ther percentage 1.8% and Number of Days in Month 31
days. How do I calculate this to get the number of "hours NPT"?
Click to expand...
 
Back
Top