mistahmistah
New Member
- Joined
- May 8, 2014
- Messages
- 21
Hello,
I'm trying to calculate how many employees I can have complete installs in a day at the given min and max rates. In order to get Min and Max Installs/Day the calculation is =B3*D3*24. Without using the 24 calculations are off. In FTE Min I'm attempting to divide "Min Installs/Day" / "FTE Cap." This should give me 3.07, but I'm receiving "20:18." How would I fix this? Converting both Min and Max Installs/Day into time? What is that conversion formula? Other suggestions? Please help.
<colgroup><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
I'm trying to calculate how many employees I can have complete installs in a day at the given min and max rates. In order to get Min and Max Installs/Day the calculation is =B3*D3*24. Without using the 24 calculations are off. In FTE Min I'm attempting to divide "Min Installs/Day" / "FTE Cap." This should give me 3.07, but I'm receiving "20:18." How would I fix this? Converting both Min and Max Installs/Day into time? What is that conversion formula? Other suggestions? Please help.
Install Rate | Min Received | Max Received | Min Installs/Day | Max Installs/Day | FTE Cap | FTE Min | FTE Max |
1:00 | 20 | 25 | 20 | 25 | 6:30 | ||
1:00 | 20 | 25 | 20 | 25 | 6:30 | ||
0:30 | 10 | 15 | 5 | 7.5 | 6:30 | ||
0:30 | 3 | 5 | 1.5 | 2.5 | 6:30 | ||
0:30 | 3 | 5 | 1.5 | 2.5 | 6:30 | ||
0:30 | 3 | 5 | 1.5 | 2.5 | 6:30 |
<colgroup><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>