11-17-2018 10:44 AM
Hi everyone,
I have a requirement where I need to calculate percentage of duration. I have the percentage. Number of days and number of hours separately. Any way to calculate the number days and hours , equavalent to percentage of actual duration.?
11-17-2018 5:31 PM
Can you clarify a little bit more with an example of as to what you are trying to do here ?
I would convert the hours to days (i.e. divide by 24 ) so 2 days and 10 hours will be something like 2.416 days, then convert the duration to days too..say 2 hrs - 0.08 days and calculate the percentage - i.e. (0.08/2.416)X100 = 3.31% . Is that what you are trying to do here ?
11-17-2018 5:31 PM
Can you clarify a little bit more with an example of as to what you are trying to do here ?
I would convert the hours to days (i.e. divide by 24 ) so 2 days and 10 hours will be something like 2.416 days, then convert the duration to days too..say 2 hrs - 0.08 days and calculate the percentage - i.e. (0.08/2.416)X100 = 3.31% . Is that what you are trying to do here ?
11-26-2018 7:00 AM
Just wanted to know if there is any standard FM that does the job for me. Created the custom one anyway.
11-18-2018 12:51 AM