# Multiplying Time and Numbers

#### mistahmistah

##### New Member
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>

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Is it?

=E3/(G3*24)

#### mistahmistah

##### New Member
Andrew,

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

Thank you!

#### Andrew Poulsom

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

Replies
3
Views
182
Replies
1
Views
190
Replies
3
Views
512
Replies
0
Views
787
Replies
4
Views
322

1,191,417
Messages
5,986,446
Members
440,030
Latest member
ninomato

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back