Average

[gautik92]

I have a table with start time and end time lik this

EmplID      StartTime   EndTime

1                08:00:00      10:00:00

2                10:00:00      11:00:00

I want to calcluate average time spent

[#2]

Hi,

sum((StartTime-EndTime)/(StartTime+EndTime))

[#3]

Hi,

You can also use the avg function

[jonathandienst · Accepted solution]

Assuming that the start time and end time are proper QV time values, then

     Interval(Avg(EndTime - StartTime))

If they are string values

     Interval(Avg(Time#(EndTime, 'hh:mm:ss') - Time#(StartTime, 'hh:mm:ss')))

Interval can also take a format parameter, so you can format the result (for example as hours  Interval(..., 'h')

[gautik92]

it dint work