Recent content by mdionne

Yes we have staff committing to time all across the board. I want to convert it using their tenure to the equivalent number of hours our seasoned staff would spend to achieve the same production. However, I'm dealing with 300 people with varying schedules AND lots of new hires. I want to...

Looking for formula help. I have one cell that lists employee tenure, another that lists committed hours, I want to return hours with a new hire factor to accurately predict working hours equivalent to seasoned staff. Using this scale, 2 week tenure = 50%, 3 week = 62.5%, 4 week =75%, 5 week =...