• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1379
  • Last Modified:

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.


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
Dan Purcell
Dan Purcell
1 Solution
Wouldn't you be happier with a formula?

Cell A2 and B2 are the length and width
Cell C2 is the time in minutes

The formula calculates the square feet per hour.
Say those values are respectively in A2, B2 and C2, then enter a formula in D2:


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:
formula for hours would be:

so to get amount per hour formula would be:
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

Open in new window

Dan PurcellManagerAuthor Commented:

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now