Feb Mar Apr
Hours Allotted 20 20 20
2 Hours Billed 20
3 Remaining Hours =B2-B3 =C2-C3 =D2-D3
5 Carry over from Previous
Mn 2 =IF(B3=0,0,IF(B6<10.01,B6,10)) =IF(C3=0,0,IF(C6<10.01,C6,10))
6 Authorized for the month =B4+B5 =C4+C5 =D4+D5




"Johnnie" wrote:

I have created simple sheet in excel.

February March April
Hours Allotted 20.00 20.00 20.00
Hours Billed
Remaining Hours 20.00 20.00 20.00
Carry over from Previous Month 10.00 10.00
Authorized for the month 30.00 30.00