Trying to Divide a duration by number

Question

Hello,
I am working on doing time studies in a manufacturing environment. I have Start/Stop time of operations into a "duration" field. During this "duration", that may have yielded 10 widgets. I am trying to divide that duration by the 10 widgets to calculate a duration per widget. I am having trouble with QB letting me divide a duration by a number.

Thanks for your help

------------------------------
Sam Ulmer
------------------------------

MarkShnierYou · Answer

np,Make a formula numeric field called called [Widgets per hour] [#Widgets Produced] / ToHours([Duration])​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community