Using sq ft with time of production

[craigwojo]

I'm trying to get a formula and just shaking my head trying to figure it out.

I have a large format printer and I need to input the size of the print. A1(inches format) *A2(inches format) / 144 with cell A3 giving me the square footage. Ok, I've got that but now comes where I'm pulling my hair out. I want to have an input cell (B1) to put in a figure that the printer speed will be. (I will input the speed) Let's say 340 sqft per hour. I would put in the "340." Now what I need is a cell that will tell me how long it will take to print the value of cell "A3" in minutes.

I hope this makes sense.

Thank you and God bless,
Craig

 

[Logit]

Don't mean to throw a wrench in your goals ... but won't the actual ability of the printer have an effect on it as well ?

 

[Logit]

	A​	B​
1​	Inches​
2​	500​
3​	3.47​	=A2/144
4​	0:00:15​	=(A3/340)/60

 

[Fluff]

How about

+Fluff New.xlsm
	A	B
1	34
2	720
3	340	30
Main

Cell Formulas
Range	Formula
B3	B3	=(A1*A2/144)/A3*60

 

[craigwojo]

Is there a way of making the answer in B3 show Hours: Minutes: Seconds? ie. 00:21:34

 

[Fluff]

How about
=(A1*A2/144)/A3/24

and format the cell as time