I need help with a vacation formula. I have 4 employees who start accruing vacation on their start date. They accrue 3.34 hrs per pay period. They are paid bi-weekly. The vacation is a use it or loose it by the end of the year. Can someone please help?
What if they are off during the bi-week period for one or two days?
Should not you change your rates to hourly/daily?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Divide 3.34 by 10 (the number of working days in a pay period) and then times that by the number of days they actually work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks