Hello everyone,

I need some help. I am trying to create a timesheet that will account for current total, used and accrued vacation and sick time.

In the example I provided you can see John used 8hrs of vacation in pay period 1 and it subtracted from his total. My problem is I cannot come up with a way to add the 5hrs he accrues each pay period.

The same goes for sick time accrual.

Here is the example.

PAYROLL EXAMPLE.xls

Any suggestions will be helpful.

Thanks,