Hey everyone - I'd really appreciate some help
I attached a file showing the format that I needed for the Productivity calculation.
Where I have given the Number of tasks achieved in one hour in B Column,
And what I needed is When I input the number of task alloted field in C, the result should be displayed in the D column in hours depending on the productivity of Column B.
Thanks in Advance.
Let me know if you have any questions.
Last edited by mutkumram; 11-19-2011 at 02:42 AM.
In D2: =C2/B2
Entia non sunt multiplicanda sine necessitate
Hi,
Thanks for the quick response. It would be fine if I got the result in Minutes. Since I am getting the result as 1.53 and some times I am getting the result as 0.69 which is hard to calculate the Minutes. Is there any suggestions to find the exact time for the completion of the tasks.
For example if the result shows as 0.69 or 0.72 or 0.82 it should shows the result as exact minutes.
I have attached the result for your reference.
Can anyone suggest me on the attached example...Thank you
Hello
To convert hours and minutes from a decimal number to the hh:mm:ss format,
use the following formula:
Use this formula to convert 11.50 minutes to 0:11:30:
Please Login or Register to view this content.
Use this formula to convert 11.5 hours to 011:30:00:Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi,
I have tried with the above said example can you explain with the example what I shown in the attached test xls file. It would really fine.
For example:
Queue Producitivy Task alloted Required time
vtmail/no9 7.29 5 0.69
If you see the required time its showing in 0.69 Minutes but I need the exact result as Minutes and seconds needed for this sample. Hope this would help you to understand my question.
Here is your sample
In D2: =C2/B2/24 and format as [h]:mm
Please Login or Register to view this content.
I got the solution Thank you all for your best suggestions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks