RonNCmale
04-08-2010, 01:05 AM
:banghead:
Employees earn 7.23 hrs if employed less than two years
Employees earn 8.46 hrs if employed two years but less than 5 years
Employees earn 10.31 hrs if employed five years but less than 10 years
I need a formula for excel that will calculate from their hire date to today's date to have enter their appropriate leave based on years of service.
Employees earn 7.23 hrs if employed less than two years
Employees earn 8.46 hrs if employed two years but less than 5 years
Employees earn 10.31 hrs if employed five years but less than 10 years
I need a formula for excel that will calculate from their hire date to today's date to have enter their appropriate leave based on years of service.