1 Reply Latest reply: Dec 10, 2012 4:52 AM by Wojciech Parzyszek RSS

    Runtime average

    steve peroni


      I've two time stamp field for each record:

      StartTime operation

      EndTime operation


      I needed to calculate the duration and I  wrote  Endtime - StartTime. Into my graph I see the correct value.

      Now I would have the runtime avg for each document type, but I'm getting wrong values. I tried  avg(Endtime - starttime), but it's wrong.


      For example


      SAles orders          2h and 15 minutes

      Invoices                    30 minutes

      purchase orders       1h 12 minutes




      How can I solve it ?

      Help please

      Thanks in advance