Bernard,
assuming you have datetime type values and they don't span more than a day:
lnElapsedTime = tOut - tIn
? ttoc( {^2000-01-01 00:00} + lnElapsedTime, 2 )
Will give you a string in hh:mm:ss format. lnElasped could also by average time in seconds too.
>I have this report which displays Time In , Time Out, and the difference between them as Character fields in a report. The difference field is calculated and in the table.This has been calculated and converted to a decimal fraction. ie 2.25 minutes = 2 minutes and 15 seconds. The total column has an average of this difference using the AVG() function in the report.
>
>The client now wants the diff time in actual minutes and seconds - 2.15 = 2 minutes 15 seconds rather than in decimal base 10.
>
>The problem is in getting the totals and the Average difference as the records are grouped by client.
>
>Any wat this can be done. See below for how the report is needed:
>
>CLIENT NAME: AABB Transport Co.(group by)
>
>Time In Time Out Time Onsite
>12:45 13.25 00:40
>12:55 14:05 01:10
>-------------------------------
>Average Onsite == 00:55