4 Replies Latest reply on Feb 19, 2013 10:24 AM by Bernardo Roschke

    Duration Calculation

    Bernardo Roschke

      I'm trying to calculate time duration of work orders [WO] based on start and end times. I have the following formula, DATEDIFF('minute',[Start Time],[End Time])/60 which works. But there are cases when a work order is split into multiple sub-work orders. This formula will multiply time duration by the amount of sub work orders.

       

      The attached shows QTY, which I'm trying to match via my duration calculation. Work Orders will not be in the view but are only present to show the effect of sub work orders on the Duration Calculation. The desired result is that QTY and Duration match without WO in the view.

       

      Thanks and let me know if I was not clear.