Need help with formula on this spreadsheet

[ladyinblack1964]

Hello, thank you for adding me. I am not very good with Excel so I need a hand with a spreadsheet, which is attached.
Someone else created this for me years ago. Basically, it added in the hours of leave I earned each month, and allowed me to subtract the hours I used. I was earning 11.67 hours per month.
Everything was going along okay until my employer changed all the paid time off rules.
I have put the amount of time I already have in my PTO bank in the top line. I've also put 11.67 hours that I am earning currently.

As of September 1, 2021, I will be earning 13.42 hours biweekly.
After my 10th anniversary with my employer on August 17 of next year, I will be earning 16.34 hours biweekly.

Leave accrual begins on September 1, and must be used in its entirety by August 31 of the following year.

I need someone to create a formula that reflects what I will now be earning biweekly. The original formula was a "=D28+B29-C29" kind. But I don't know how to fix it so it reflects biweekly deposits to my PTO bank.

I hope this all makes sense. I think it is a pretty easy formula for folks who already know how to use the program well! Many thanks!

New PTO Balance 2021-2022.xlsx
	A	B	C	D
1	Month	Time Earned	Time Used	Balance
2	end of July 2021			42.01
3	August	11.67
4	September
5	October
6	November
7	December
8	Jan-22
9	February
10	March
11	April
12	May
13	June
14	July
15	August
16	September
17	October
18	November
19	December
20	Jan-23
Sheet1

 

[Dave Patton]

If necessary, edit the start date.

T202108a.xlsm
	A	B	C	D
1	Month	Time Earned	Time Used	Balance
2	31-Jul-21			42.01
3	31-Aug-21	11.67		53.68
4	14-Sep-21	13.42		67.10
5	28-Sep-21	13.42		80.52
6	12-Oct-21	13.42		93.94
7	26-Oct-21	13.42		107.36
8	9-Nov-21	13.42		120.78
9	23-Nov-21	13.42		134.20
10	7-Dec-21	13.42		147.62
11	21-Dec-21	13.42		161.04
12	4-Jan-22	13.42		174.46
13	18-Jan-22	13.42		187.88
14	1-Feb-22	13.42		201.30
15	15-Feb-22	13.42		214.72
16	1-Mar-22	13.42		228.14
17	15-Mar-22	13.42		241.56
18	29-Mar-22	13.42		254.98
19	12-Apr-22	13.42		268.40
20	26-Apr-22	13.42		281.82
21	10-May-22	13.42		295.24
22	24-May-22	13.42		308.66
23	7-Jun-22	13.42		322.08
24	21-Jun-22	13.42		335.50
25	5-Jul-22	13.42		348.92
26	19-Jul-22	13.42		362.34
27	2-Aug-22	13.42		375.76
28	16-Aug-22	13.42		389.18
29	30-Aug-22	16.34		405.52
1e

Cell Formulas
Range	Formula
A4:A29	A4	=A3+14
D3:D29	D3	=D2+B3-C3

 

[ladyinblack1964]

If necessary, edit the start date.

T202108a.xlsm
	A	B	C	D
1	Month	Time Earned	Time Used	Balance
2	31-Jul-21			42.01
3	31-Aug-21	11.67		53.68
4	14-Sep-21	13.42		67.10
5	28-Sep-21	13.42		80.52
6	12-Oct-21	13.42		93.94
7	26-Oct-21	13.42		107.36
8	9-Nov-21	13.42		120.78
9	23-Nov-21	13.42		134.20
10	7-Dec-21	13.42		147.62
11	21-Dec-21	13.42		161.04
12	4-Jan-22	13.42		174.46
13	18-Jan-22	13.42		187.88
14	1-Feb-22	13.42		201.30
15	15-Feb-22	13.42		214.72
16	1-Mar-22	13.42		228.14
17	15-Mar-22	13.42		241.56
18	29-Mar-22	13.42		254.98
19	12-Apr-22	13.42		268.40
20	26-Apr-22	13.42		281.82
21	10-May-22	13.42		295.24
22	24-May-22	13.42		308.66
23	7-Jun-22	13.42		322.08
24	21-Jun-22	13.42		335.50
25	5-Jul-22	13.42		348.92
26	19-Jul-22	13.42		362.34
27	2-Aug-22	13.42		375.76
28	16-Aug-22	13.42		389.18
29	30-Aug-22	16.34		405.52
1e

Cell Formulas
Range	Formula
A4:A29	A4	=A3+14
D3:D29	D3	=D2+B3-C3

Thank you very much! I think this should do it.
Only (and I hope this does not make me sound stupid) I don't understand how to get the information from the mini sheet to my own spreadsheet. I also am not sure how to or where to enter the formulae. I tried to do it and I got ##value##. I confess I know little or nothing about Excel.

Is there a way to download the mini sheet so I can just use that?

Thanks!

 

[Peter_SSs]

Is there a way to download the mini sheet so I can just use that?

Open a blank worksheet.
Click this button on Dave's mini-sheet

Select cell A1 in your blank worksheet.
Paste

 

[ladyinblack1964]

Thank you very much! This is a huge help to me.

 

[Peter_SSs]

Thank you very much! This is a huge help to me.

No problem.

 

[Dave Patton]

Thanks for the feedback.