| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
