Calculating throughput

I have a table with Runtime in hh:mm and Quantity.  I'd like to calculate throughput in Quantity/Hour.

Everytime I try to come up with an equation, the numbers don't sync.  I need to convert the hh:mm to hours ie. 01:30 = 1.5 hours.
dakarrAsked:
Who is Participating?
 
lmerrellConnect With a Mentor Commented:
dakarr,

Try this as your equation:

Quantity / (DatePart("h",[Runtime]) + (DatePart("n",[Runtime]) / 60))

lmerrell
0
 
dakarrAuthor Commented:
Thank-you.

How can I format that so there are no decimal places?
0
 
lmerrellCommented:
Are you wanting the final throughput to be an integer?  If so, use:

CInt(Quantity / (DatePart("h",[Runtime]) + (DatePart("n",[Runtime]) / 60)))

lmerrell
0
 
dakarrAuthor Commented:
Yes.  Thanks so much.

0
 
lmerrellCommented:
No problem!  Have a great New Year!

lmerrell
0
All Courses

From novice to tech pro — start learning today.