Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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 "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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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? "Mike" wrote: 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 "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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
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"? "Peledon" wrote: 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 Hours NPT? "Mike" wrote: 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 "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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
One way:
=1.8% * 31 * 24 In article , Peledon wrote: 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"? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Percentage to total number of NPT Days
to solve for NPT use 1.8%*31
Mike "Peledon" wrote: 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"? "Peledon" wrote: 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 Hours NPT? "Mike" wrote: 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 "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? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. "Mike" wrote: to solve for NPT use 1.8%*31 Mike "Peledon" wrote: 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"? "Peledon" wrote: 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 Hours NPT? "Mike" wrote: 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 "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? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 * 24 In article , Peledon wrote: 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"? |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
convert dates to number of days | Excel Worksheet Functions | |||
Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
a number as a percentage out of a total | Excel Worksheet Functions |