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.

[TABLE="width: 655"]
<colgroup><col><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Install Rate[/TD]
[TD]Min Received[/TD]
[TD]Max Received[/TD]
[TD]Min Installs/Day[/TD]
[TD]Max Installs/Day[/TD]
[TD]FTE Cap[/TD]
[TD]FTE Min[/TD]
[TD]FTE Max[/TD]
[/TR]
[TR]
[TD="align: right"]1:00[/TD]
[TD] 20[/TD]
[TD] 25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6:30[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]1:00[/TD]
[TD] 20[/TD]
[TD] 25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6:30[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0:30[/TD]
[TD] 10[/TD]
[TD] 15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7.5[/TD]
[TD="align: right"]6:30[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0:30[/TD]
[TD] 3[/TD]
[TD] 5[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]6:30[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0:30[/TD]
[TD] 3[/TD]
[TD] 5[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]6:30[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0:30[/TD]
[TD] 3[/TD]
[TD] 5[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]6:30[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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?