Convert Percentage to total number of NPT Days
THANK YOU
1.8 * 31 * 24/100 = 8.75 this is exactly what I'm looking for many thanks.
"JE McGimpsey" wrote:
One way
=1.8% * 31
will give the number of days NPT
In article ,
Peledon wrote:
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?
"JE McGimpsey" wrote:
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?
In article ,
Peledon wrote:
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?
|