9 Replies Latest reply: May 6, 2015 5:11 AM by Joanna Seldon RSS

    Total time for number of records not single record

    Joanna Seldon

      Hiya

       

      this code below works great to calculate total time when you select a single customer ID

       

       

       

      Interval(Date#([DateOrderCompleted], 'DD/MM/YYYY hh:mm:ss') - Date#([DateOrderReceived], 'DD/MM/YYYY hh:mm:ss'), 'hh:mm:ss' )

       

      However ...I wish to calculate the total time for all customers (not single) within a certain department

       

       

      I have tried adding sum and count, but I get error

       

      any ideas please

       

      kind regards

       

      joeybird