Timesheet vacation & sick time accrual

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,

What about populating Totals!H31 with

Please Login or Register  to view this content.

and Totals!H32 with

Please Login or Register  to view this content.

. Select both cells and drag the formulas across to column I

I have added the accruals to the pay period sheets, allocating the specified amount of acrued vacation time and sick leave to the WEEKDAY formula. - This will give the specified accrued time only on weekdays, not on weekends. On the total sheet, you will have to adjust the formula on whether you want running totals or not.
Hope this will get you started in the direction you need.