Runtime average

[Anonymous]

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

[#2]

why don't you calculate your duration time in load script as an aditional field