Is there a way to track vacation time.
In our Company you get
1 week after 1 year of service
2 weeks after 3 years
3 weeks after 5 years.
I have attached a sheet showing everyone's date of hire. and then want to be able to input how many hours they have used and have the balance of what is remaining reflected as well and if it reaches zero there is some sort of alert to make us aware.
If i am asking to much of excel please let me know.
Vacation time calculator.xlsx
=DATEDIF(C3,TODAY(),"m")
will return service months
=INT(MIN(36,H3)*40/12)
will return pro-rata vacation hours (service months in column H)
See attached
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
With service months in column H as per John's workbook above, vacation weeks =LOOKUP(H3,{0,12,36,60},{0,1,2,3}), assuming no pro-rate.
At Josephteh would this replace the formula in Column I.
They only get 40hrs after 1yr
they get 80 hrs after 3years
and 120hrs after 5 years.
For vacation hours, =LOOKUP(H3,{0,12,36,60},{0,40,80,120}).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks