| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
| how do i calculate hours worked in excel? | Excel Worksheet Functions | |||
| quattro pro converter Excel 2003 | New Users to Excel | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
