Solved

# Square feet an hour calculator

Posted on 2013-10-24
633 Views
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
0
Question by:Dan Purcell

LVL 80

Expert Comment

ID: 39598758
Wouldn't you be happier with a formula?
=IF(COUNT(A2:C2)=3,(A2*B2/144)/(C2/60),"")

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
0

LVL 23

Expert Comment

ID: 39598761
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.
0

LVL 9

Expert Comment

ID: 39598788
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)
0

LVL 80

Accepted Solution

byundt earned 500 total points
ID: 39598793
Here is a macro as requested:
``````Sub SquareFtPerHour()
Dim dLength As Double, dWidth As Double, dTime As Double, dSquareFtPerHour As Double
On Error Resume Next
dLength = InputBox("Please enter the length of the sheet in inches")
dWidth = InputBox("Please enter the height of the sheet in inches")
dTime = InputBox("Please enter the time that it took to print in minutes")
On Error GoTo 0
If dLength * dWidth * dTime > 0 Then MsgBox (Format((dLength * dWidth / 144) / (dTime / 60), "#.0") & " square feet per hour")
End Sub
``````
SquareFtPerHour.xlsm
0

Author Closing Comment

ID: 39598807
Wow!!
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

#### 744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!