what is the total number of staff as i think you may need that if you have the movement hired less terminated / total number of staff this will give you your turnover in % I beleive.
kitty
I posted this under percent to ratio but didn't realize the thread was a year old.
I have the opposite question. How do you convert a ratio to a percentage.
Say I hired 41 people and had to terminate 25. What is the turnover ratio percentage. I used =SUBSTITUTE(TEXT(41/25,"?/?"),"/",":") which got me a 5:3 ratio but I guess I'm looking for a percentage of turnover.
Last quarter it was hire 27 and termed 20 and they came up with 17% I've done everything possible to figure out how they calculated that but it's more like 68%. If you only retained 7 of the 27 you hired it seems it would have to be a much higher percentage.
Can anyone help?
what is the total number of staff as i think you may need that if you have the movement hired less terminated / total number of staff this will give you your turnover in % I beleive.
kitty
Hi,
How about:
=1/TEXT(41/25,"0.000") and format cell as %
"Fair Winds and Following Seas"
Thanks for the replies. At least I think I was on the right track.
That's is more in line with what I thought it should be - it came out to be 61%. I still don't know how they got a 17% turnover when they hired 27 and lost 20. The total number of employees averages around 140. I questioned whether that should be in the equation too.
If I use the above in the formula the percentage ratio is 74% not 17%.[/img]
turnover rate - the ratio of the number of workers that had to be replaced in a given time period to the average number of workers.
TOR=(num. who left/avg. num. of emps.)*100
=(25/140)*100
=17%
So the number of hires doesn't enter into the equation. Well at least you got me to 17%. Thanks so much.
Like this thread? Share it with others