Forum Discussion

SamUlmer1's avatar
SamUlmer1
Qrew Member
4 years ago

Trying to Divide a duration by number

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
------------------------------
  • np,

    Make a formula numeric field called called [Widgets per hour]

     [#Widgets Produced] / ToHours([Duration])


    ā€‹

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------