Multiplying Time and Numbers

[mistahmistah]

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.

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>

 

[Andrew Poulsom]

Is it?

=E3/(G3*24)

 

[mistahmistah]

Andrew,

That worked! However, I would like Columns D and E to represent time. Any recommendation there?

Thank you!

 

[Andrew Poulsom]

Sorry, I don't understand. What range does your sample data occupy?