May 3, 2019
I am trying to determine in one step the carryover amount of vacation hours that an employee has over and above their allowable limit.
Column C - current vacation hours in the bank
Column D - Entitlement for new Fiscal that just started
Column E - Previous Fiscal's entitlement
Column F - Amount of previous year's Fiscal which they are entitled to carryover half (which is half)
Column G - If their current vacation balance (column C) is greater than their entitlement (column D) what is this amount (this is the amount they are over)
Column H - And if this overage is greater than their allowable carryover (column F). If true what is the amount and if false "okay"
November 1, 2018