ExcelBanter - Vacation accrual based on hours worked

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vacation accrual based on hours worked - Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/61328-vacation-accrual-based-hours-worked-excel-2003-a.html)

CCB AA

Vacation accrual based on hours worked - Excel 2003

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

David Billigmeier

Vacation accrual based on hours worked - Excel 2003

(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?
--
Regards,
Dave

"CCB AA" wrote:

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

All times are GMT +1. The time now is 11:13 AM.