Adding Hours automatically

Question

I have a schedule and 60 employees with different earned hours after their time in service. How do I have excel automatically add to existing accumulated hours and continue to do so at the end of the month. Example, If I had an employee with 20 hours, and he earns 8 hours each month, excel will automatically update to 28 first month, 36 second month. Some earn 8 hours, 10 hours, 12 hours and 14 hours. I dont have much experience with formulas so be patient with me. If it can be done with a formula vs a VBA, it would prefer formula, but am willing to try anything to increase knowledge. Also, can I set up another cell so that if an employee uses 10 hours, it will subtract those hours. I need the other cell to show he/she has used so many hours in a given period. Thank you for your time in this matter.

Answer 1

Sorry for the confusion. Those hours listed are current hours that they have on the books. I wanted excel to add hours in the Annual column based on their time with the company.

So, lets say employee #2, who currently has 177 hours that is on the books. If that employee has been with us for 121 months, I wanted excel to ad 10 hours to 177 and make that 187 at the end of each month.

Another example, if employee #5 has 251 hours and they have been employed for 190 months, then I wanted excel to add 14 hours and make the total at the end of the month now say 265 hours, because they have been employed for more that 180 months.

The value for annual is based upon years of employment. 8 hours per month up to 36 months. Starting 37 month to 120 months is 10 hours per month. Starting the 121 month to 180th month is 12 hours earned per month. The 181 month till retirement is 14 hours per month.

I know that I did not explain in detail and I will try to be more detailed from this point on.

Answer 2

Hi,

Hire date	Annual	Months	Annual should be	1	8
07/07/2003	12	134	12		37	10
10/04/2006	177	100	10		121	12
24/06/2013	32	14	8		181	14
18/02/2003	251	138	12
23/04/2007	280	88	10

Based on your explanation, how do you come to 177 for the 2nd employee? It should be 100.

Answer 3

1. The value for annual is based upon years of employment. 8 hours per month up to 36 months. Starting 37 month to 120 months is 10 hours per month. Starting the 121 month to 180th month is 12 hours earned per month. The 181 month till retirement is 14 hours per month.
2. Based on years of employment. I can access their years and months and have that information available.
3. By other values I think you mean Holidays are earned 8 hours once the holiday has passed.  Sick leave is earned at the end of the month, the same as Annual. Annual and sick are added at the end of each month. Comp or compensation is earned as the employee has worked extra hours and is the same as overtime.

I hope I have answered the questions for you to understand. If clarifications are needed, please let me know. I can also modify and add columns for that information to be added.

Answer 4

I just want to  say  thank you for all your efforts. Whatever you need, I will  give you the information. Let me know what you need and I will respond.

Hi Carl,

First of all I have to say that this forum is not a free developers forum that will work out complete projects. Most of us are volunteers spending their spare time to help people further.

Having said that, I do not mean that we will not further assist.

So, start thinking about these 3 questions:

1. How do you get the value for "Annual"
2. How do you know how much hours an employee has earned.
3. How do you come to the other values.

Answer 5

I just want to  say  thank you for all your efforts. Whatever you need, I will  give you the information. Let me know what you need and I will respond.