Calculate an average a on Time (HH:MM) field

Wed, 07 Aug 2013 13:48:40 GMT

Hello,

In a dynamic cross table, I would like to calculate an average a on a field which contains a time (HH:MM).

The type of this field is TIME.

Could you help me / show me how to make this calcule ?

Exemple 1 :

--> 10h00 am

--> 10h15 am

--> 10h30 am

The average calcul should give me 10h15.

Exemple 2 :

--> 10h45 am

--> 11h00 am

--> 11h15 am

The average calcul should give me 11h00.

Thanks in advance if you can help me.

Regards,

Jérémie

Re: Calculate an average a on Time (HH:MM) field

Wed, 07 Aug 2013 13:59:02 GMT

The answer is :

avg(nam_of_field)

and click HOUR in tab number.