Dan Purcell
asked on
Square feet an hour calculator
I didn't do very good in high school math! I would like to write a macro that I could enter the height and width of a sheet and the amount of time it took to print it and come up with the square feet an hour.
Example:
24" x 48" = 8 sqft
It took 5.5 mins to print
?= "how many square feet and hour that would equal" (around 88sqft an hour I think)
The 24 and 48 would be variable as would the time.
I hope that's clear enough
Example:
24" x 48" = 8 sqft
It took 5.5 mins to print
?= "how many square feet and hour that would equal" (around 88sqft an hour I think)
The 24 and 48 would be variable as would the time.
I hope that's clear enough
Say those values are respectively in A2, B2 and C2, then enter a formula in D2:
=A2*B2/144/C2*60
so you multiply the sides in inches, and divide by 144 to get square feet. Then divide by time in minutes and multiply by 60 minutes/hour.
=A2*B2/144/C2*60
so you multiply the sides in inches, and divide by 144 to get square feet. Then divide by time in minutes and multiply by 60 minutes/hour.
enter height in a1
enter width in b1
enter time in c1
formula for square footage would be:
=a1*b1
formula for hours would be:
=c1/60
so to get amount per hour formula would be:
=(60/(C1/60))*(A1*B1)
enter width in b1
enter time in c1
formula for square footage would be:
=a1*b1
formula for hours would be:
=c1/60
so to get amount per hour formula would be:
=(60/(C1/60))*(A1*B1)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow!!
=IF(COUNT(A2:C2)=3,(A2*B2/
Cell A2 and B2 are the length and width
Cell C2 is the time in minutes
The formula calculates the square feet per hour.
SquareFtPerHour.xlsm