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:

ABCDEFGHIJ
1July 20, 2019Job 123
2Cost Code: Example 1BobCarolTedAliceBudget HoursRemaining HoursTOTALS
3PO # XYZ
40000000001Task One4.0100.096.04.0
50000000002Task Two5.0100.095.05.0
60000000003Task Three6.0100.094.06.0
70000000004Task Four7.0100.093.07.0

Sheet1



Worksheet Formulas
CellFormula
I4=H4-J4
J4=SUM(C4:F4)
I5=H5-J5
J5=SUM(C5:F5)
I6=H6-J6
J6=SUM(C6:F6)
I7=H7-J7
J7=SUM(C7:F7)



Thanks