trying to average my HMS

[Nymandus]

I have my call length set to Hours Minute seconds
that we data enter as 00:06:59 for six minutes 59 seconds

in my report I would like to show the average of this for certain criteria but it returns an odd number
=Avg([CallLength]) as 800.40 for example

so I thought if I coudl tell it how to return the data it woudl help but I can not figure out a "like" statement

=Avg([CallLength]) as "00:00:00"

is there a way to do this?

 

[CJ_London]

It depends on what the field type is.

Date fields are stored as a decimal number, the date 'value' is to the left of the decimal and the hms to the right as a fraction of 24hrs*60mins*60secs.

to format your value you use the format function

format(myvalue,"hh:nn:ss")