Running Totals Calculating Overtime?

[WraithMistress]

Hi Everyone! Hope someone can help with this. I am having a hard time wrapping my head around it, so anything will be useful! Thanks in advance!

I need to track employee overtime that needs to be used in 3 months, for example:

Employee A: did overtime on July 1 for 8 hrs, which is banked at 12 (time and half) These 12 hours need to be used up by Oct 1 (3 months from date worked) otherwise they are paid out...

I have set up a spreadsheet with the following:
Date Worked
Hours Worked (input the 8 hours)
At 1.5 (calculates the time and a half) 12
Must be used or paid out by (I have a date formula that returns 3 months)
Date Used
Banked time used (can only be in units of 8 hrs or less)
Paid Out (will pay out 12)

Problem is simple getting around it, not so much! Employee A works July 1, and banks the 12 hours, Uses the banked time on Aug 15 using 8 of the 12 hours, I still need a way to track the remaining 4 hours and ensure that it is being used BEFORE Oct 1st.

HELP!

 

[Dryver14]

This may be too simple for what for what you want but if you just add the hours used to column E it works

Excel Workbook
	A	B	C	D	E	F
1	Date	HRs	1.5	3 months	used	to pay
2	14/03/2011	8	12	12/06/2011	8	4
Sheet1

 

[WraithMistress]

Thanks Dryver14! This is a good start, let me put it together on a sheet and run some scenarios and see what happens...for me, it may work, but I am creating this for non-techies...

This may be too simple for what for what you want but if you just add the hours used to column E it works

Excel Workbook
	A	B	C	D	E	F
1	Date	HRs	1.5	3 months	used	to pay
2	14/03/2011	8	12	12/06/2011	8	4
Sheet1