Vacation/Sick Leave accruals

**Carisa** · 09-27-2012, 07:36 PM

Hi. New here, and I need help! I am "formula" and "function" handicapped!
For a small church semi-monthly payroll, I'm developing an Excel worksheet to track vacation & sick leave beginning balances (Column A - a hard # will be entered), hours used this pay period (Column B - a hard # will be entered each pay period), hours accrued this pay period (Column C - need a formula here based on 4 hours max accrual, but less if it causes the ending bal to exceed 96) and ending balance (Column D - need another formula here... beg bal, minus usage, plus accrual, the sum of which cannot exceed 96 for a full-time [40 hour/wk] employee).
If anyone here can help, I would sure appreciate it!
Thanks.

**tuph** · 09-27-2012, 08:42 PM

It would help if you can upload a sample of your worksheet so we can see the formulas you are working with. Be sure to replace any sensitive or confidential data before uploading.

**Carisa** · 09-27-2012, 08:48 PM

Trish in Oz...
How do I attach the worksheet once I've posted the question? Thanks!

**tuph** · 09-27-2012, 09:04 PM

Click on "Reply to Thread" to create a new message in this thread.

Scroll down and click on "Manage Attachments". At top right click "Add Files" then "Select Files". Browse to find your file then click "Save". Click "Upload Files" then click "Done".

Scroll down again and check that the filename appears below the "Manage Attachments" button then click "Submit Reply".