Vacation accrual based on hours worked - Excel 2003

G

Guest

need template or formula to compute number of hours of vacation accrued per
4o hour work week -- 15 days of vacation per year -
Excel 2003
 
G

Guest

(15 days of vacation per year) * (8 hours a day) = 120 Hours of vacation per
year

(120 hours of vacation per year)/(52 weeks in a year) = 2.308 hours accrued
per week.

Does that help?
 

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

Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
Vacation accrual based on years with rollover 1
Vacation Accrual formula 1
Vacation Accrual 1
IF-AND-OR? 5
vacation accrual formula 2
Calculate Months to Determine Length of Service 7
How do I calculation vacation accrual? 1

Top