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

Hi Carl,

The answer is yes and no. I say no because of the set-up of your workbook. A cell can contain a value or a formula, not both and a formula cannot update the parent cell.

It become yes if we can change all values to formulas and then we can add additional criteria to add a value. Let me try to explain.

Annual is the sum of ....

Earned hours is calculated as ....

In G2: =SUM(annual_calculation)+earned_hours_calculation

So, to help you further on this, we need much more details.

Answer 2

I want to know if excel can take the Annual cells (column G) of each employee and increase them by 8 hours or 10 hours, whatever the employee has earned  thru time in service automatically at the end of each month. By  the way, can excel add 8 hours to the holiday column(column H) of each employee after a holiday has occurred? In need to know if these  tasks can be done automatically without manual input.

Answer 3

Hi,

I had a look to your workbook. Can you explain what you want to calculate and how, it is not clear to me.

Answer 4

Here is the link to the  file.https://onedrive.live.com/redir?resid=60D31A96BA6C7160!113&authkey=!AHAjeKgAF9pZzog&ithint=file%2cxlsx

Answer 5

Hi Carl,

Best is to upload your workbook to onedrive so we can have a look and understand you better.

Please remove all confidential data before doing it.

To upload to onedrive -

1. Login to https://onedrive.live.com/
2. Open the public folder.
3. Click Upload in the top.
4. After uploading, right click it and choose share.
5. Click Get a Link.
6. In the option, choose public.
7. Create Link
8. Post the link here.