Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am attempting to calculate vacation accrual so that I can enter into
QuickBooks. Vacation accrues as follows: 1) employee gets 1 week (40 hrs) after 6 month employment 2) employee receives 1 week vacation for every 6 months worked or portion thereof 3) maximum vacation an employee can accrue is 4 weeks (160 hrs) 4) employee is paid bi-weekly (26 pay periods/2080 hrs annually) I am attempting to create a formula to calculate the bi-weekly accrual rate based on the above information. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vacation Pay Calculation | Excel Discussion (Misc queries) | |||
Vacation Time calculation... HELP! | Excel Discussion (Misc queries) | |||
Vacation Accrual formula | Excel Worksheet Functions | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions |