Ken_Davies
New Member
- Joined
- Jul 19, 2019
- Messages
- 1
Hello
I would like to be able to keep track of the allotted hours remaining for particular tasks.
We use a workbook for each day, emailing the time sheet to our main office. I enter the hours spent on a task and they are subtracted from the budget hours.
The next day I 'save as' the previous day's time sheet, make the required changes and send it off.
I would like to keep a running total of remaining hours as the number decreases from day to day.
Example:
Thanks
I would like to be able to keep track of the allotted hours remaining for particular tasks.
We use a workbook for each day, emailing the time sheet to our main office. I enter the hours spent on a task and they are subtracted from the budget hours.
The next day I 'save as' the previous day's time sheet, make the required changes and send it off.
I would like to keep a running total of remaining hours as the number decreases from day to day.
Example:
| Book1 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | July 20, 2019 | Job 123 | ||||||||||
| 2 | Cost Code: Example 1 | Bob | Carol | Ted | Alice | Budget Hours | Remaining Hours | TOTALS | ||||
| 3 | PO # XYZ | |||||||||||
| 4 | 0000000001 | Task One | 4.0 | 100.0 | 96.0 | 4.0 | ||||||
| 5 | 0000000002 | Task Two | 5.0 | 100.0 | 95.0 | 5.0 | ||||||
| 6 | 0000000003 | Task Three | 6.0 | 100.0 | 94.0 | 6.0 | ||||||
| 7 | 0000000004 | Task Four | 7.0 | 100.0 | 93.0 | 7.0 | ||||||
Sheet1 | ||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| I4 | =H4-J4 | |
| I5 | =H5-J5 | |
| I6 | =H6-J6 | |
| I7 | =H7-J7 | |
| J4 | =SUM(C4:F4) | |
| J5 | =SUM(C5:F5) | |
| J6 | =SUM(C6:F6) | |
| J7 | =SUM(C7:F7) | |
Thanks
