Hello,
I am hoping someone could be of assistance. Does anyone know how to create a maximum amount in the sum from a formula. I am creating a vacation accrual spreadsheet where the number of hours worked dictate the amount accrued, but the problem I am running into is that some employees work a lot of overtime and with the formula I am using to sum up the total for each year ( =40/2080* # of hours) some of the employees worked over 2080 hours, so they are accruing more than one week (40 hours)
YEAR Hours Worked Vacation Hours Accrued Vacation Taken Vacation Paid ACCRUED
2010 3020 58.08 0 0.00 23.44
Please help!
Thanks,
Ernie
Bookmarks