Assignment of the hours according to task and user (Hour calculation needed)

--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 :)

Fähigkeiten: Excel, Excel Macros , Excel VB Capabilities, Excel VBA, Projektmanagement

Mehr darüber needed text, calculation needed, facebook clone drupal modules needed let know, crm workflow create task user, animator animation movie hour wanted needed, php user login create excel file, start task curent hour, vbnet read excel file uploaded user, active directory excel file automate add user, powershell script add user excel file, scheduled task user log, rails list task user, hour support needed, man hour calculation excel sheet, user experience consultant needed, task prioritization app calculation, web developer hours per week per hour, is user interface design needed before hiring a developer, web developer task management hour, user experience design needed

Über den Arbeitgeber:
( 3 Bewertungen ) Berlin, Germany

Projekt-ID: #22236090

48 Freelancer bieten im Durchschnitt €25 für diesen Job


"I am an expert with great skills of data processing, Microsoft Excel, data entry and data management. I have successfully completed lot of tasks here means at You can view my profile page for my skill Mehr

€20 EUR in 1 Tag
(270 Bewertungen)

Edit: The formula addresses the situation given in Project Description. I notice that there are couple of more situations that need to be addressed and the formula below will have to be updated to cover these as well. Mehr

€25 EUR in 1 Tag
(205 Bewertungen)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Mehr

€30 EUR in 1 Tag
(164 Bewertungen)

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.

€30 EUR in 1 Tag
(198 Bewertungen)

Hi, Greetings. I went through the pdf file with requirements and understood what i need to implement into excel. Yes, we can achieve it without using vba, just need to use some functions. Plz let me know if you are in Mehr

€30 EUR in 1 Tag
(104 Bewertungen)

I can develop the hour calculation sheet with exact requirements mentioned in task excel and pdf file along with any other requirements we discuss. Please initiate chat to discuss this in detail. Please find below a br Mehr

€70 EUR in 1 Tag
(42 Bewertungen)

I possess exceptional data science and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Managemen Mehr

€19 EUR in 7 Tagen
(52 Bewertungen)

Hi, I agree with you so I do suggest VBA coding for good quality results. I have rich experience in VBA coding (API, Websacrping, Automation tasks, managing data, .....), and I do my best to save your time and pocket. Mehr

€24 EUR in 1 Tag
(57 Bewertungen)

I can definitely help you with that. I am a professional Financial Analyst, Statistical Analyst and Data Science expert holding years of experience in developing some highly and automated excel based tools and dashboar Mehr

€30 EUR in 1 Tag
(74 Bewertungen)

Hi there, YES! what you need to accomplish can be achieve using Excel in-built formulas like logical functions and modified vlook-up. My rate for this job is €25 and I can turn it around after two days. Please mess Mehr

€25 EUR in 7 Tagen
(21 Bewertungen)

Hello. Sure this can be done using a formula. You have already made some lengthy formulas using Index, match and Look ups. You can do the same here too. Calculate the sum of each user for a month separately and store i Mehr

€20 EUR in 1 Tag
(10 Bewertungen)

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

€28 EUR in 2 Tagen
(47 Bewertungen)

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

€19 EUR in 7 Tagen
(19 Bewertungen)

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project don Mehr

€30 EUR in 2 Tagen
(45 Bewertungen)

GOT YOUR TASK READY! two hours work so 30Eur is a fair price. No VBA, just one formula (you can modify one cell and copy to the rest in the work area). Send me a message and I can send you print screen of the result. I Mehr

€30 EUR in 1 Tag
(21 Bewertungen)

Hi What you are requesting is month to month getting totals from "Available" worksheet. And using that totals, setting values in worksheet "work sheet". It is easy. But is that all? Don't you need another list showin Mehr

€23 EUR in 3 Tagen
(21 Bewertungen)

Hi, The solution to your Project is ready and is elegant without any VBA.I have your solution ready and working.. Regards. Reuben

€15 EUR in 1 Tag
(15 Bewertungen)

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw Mehr

€19 EUR in 4 Tagen
(26 Bewertungen)

Hi, I go through your formulas, It seems like you haven't include the previous amount of hours that one person is working within one month for another tasks into the new task (meaning that if user 1 should work 150 hou Mehr

€30 EUR in 7 Tagen
(12 Bewertungen)

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.

€15 EUR in 1 Tag
(16 Bewertungen)