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



      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