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

    Runtime average

    steve peroni

      Hi,

      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