• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1543
  • 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:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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