US Navy Engineer
New Member
- Joined
- Jun 24, 2015
- Messages
- 1
So im making a what seems to me a complicated worksheet to track man hours and money for individuals. On one worksheet already I have a list of dates and total money raised for each specific date. On another worksheet the one im stuck on right now calculates man hours for individulas but I also want it to tally money totals to individuals. My organization has it set up so that if someone works more than 1 hour for an event they can claim the whole days take as part of their earned amount. Sample below of how I have it set up right now.
<tbody>
</tbody>
For this example each day brought in $100 dollars. I am currently doing the total raised column by hand and it is tiresome. Is there a way to link each date column to the amount raised for that day on my other worksheet and have it tallied to the total raised if the man hours block changes to anything above 0.
P.S. Sorry i would have attached photos of the books im working on but I dont have the perms.
Name | 1 DEC 15 | 2 DEC 15 | Total man hours | Total helped raised |
Chris | 5 | 0 | 5 | $100 |
Bob | 0 | 4 | 4 | $100 |
Mack | 3 | 2 | 5 | $200 |
<tbody>
</tbody>
For this example each day brought in $100 dollars. I am currently doing the total raised column by hand and it is tiresome. Is there a way to link each date column to the amount raised for that day on my other worksheet and have it tallied to the total raised if the man hours block changes to anything above 0.
P.S. Sorry i would have attached photos of the books im working on but I dont have the perms.