--we can talk about Price if it feels like too low. --
I am looking for Hour calculation of the user after assigning the task to them with some factor.
Basically what i need is a process :
I assigned the hours to the user for a task for a period eg: for jan, i assigned 152 hours and user has available 192 working hours then result should come 152 hours not 192 hours as max we need is 152 for that task. and again if i assigned task 2 to same user to work for 50 hours, it should take only 40 as user has only this monuch left for that month .
More details are in the pdf and excel file.
I made it everything Ready only thing needed is , (I guess) is the Record sheet to Minus the Already assigned hours.
But i am open to ideas.
I prefer it without VBA but if its not possible without i might consider it .. we can talk about it later.
Let me know if you think its possible.
People sending request without Reading task, will be ignored. :D
Text me :)
48 Freelancer bieten im Durchschnitt €25 für diesen Job
Hello there, I am an Excel expert and I think small VBA script can make it faster and better for you. Please contact me. I think I can do it within 2 hours. Thank you.
Hi I've viewed you Excel file..and pdf What to say ,as my experience shows here best way will be to code it via Ms Access , I'll detail on private chat Best wishes, Zurab
Hi There, I can help you to create formula for calculation hours, i have read all your requirements, i can do it just for couple hours. Please kindly chat me, i'm available now. thanks. Regards.