Convert Percentage to total number of NPT Days

[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?

 

[Guest]

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

 

[JE McGimpsey]

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?

 

[Guest]

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?

 

[Guest]

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?

 

[JE McGimpsey]

One way

=1.8% * 31

will give the number of days NPT

 

[Guest]

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"?

 

[JE McGimpsey]

One way:

=1.8% * 31 * 24

 

[Guest]

to solve for NPT use 1.8%*31

Mike

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"?

 

[Guest]

THANK YOU

1.8 * 31 * 24/100 = 8.75 this is exactly what I'm looking for many thanks.

 

[Guest]

THANK YOU

1.8 * 31 * 24/100 = 8.75 this is exactly what I'm looking for many thanks.

 

[Guest]

THANK YOU

1.8 * 31 * 24/100 = 8.75 this is exactly what I'm looking for many thanks.