Accrual of hours

N

Nazareth

How do I create a formula that will accrue vacation hours on a monthly basis?
I've created a timesheet in excel version 2003. Each workbook contains a
bi-weekly timesheet. The last workbook is a YTD (year to date). I want to
add a formula that will show each month an employee accrued 1.66 days so I
can cross check what a person has used with what a person has accrued. Can
this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Accrual Date 1
Length of Service and Vacation Hours Accrued 2
Vacation accrual based on years with rollover 1
Vacation Accrual - Challenge 2
How do I calculation vacation accrual? 1
Calculate Months to Determine Length of Service 8
Accrual Formula 3
worksheet to track vacation accrual by employee and cost/job cente 1

Top