How do I Calculating Delta Time

[Guest_imported]

Hello BRIO Experts:

Using Date and Time- and just time, How would i calculate Delta time using two colums Named "In_time" and "Out_time"

Im trying to do this in BRIO NAVAGIATOR V. 6.02
There appears to be no DELTA function for this.

How would i write the SQL or other method to do this?

Is it best to do this in the QUERY or REPORT?

All help/suggestions are appreciated.

Thank ya.

 

[thorsdata]

Hello,

Try right-clicking on the Request line, add a computed field and subtract In time from Out time. You do not need to request the individual fields.

thorsdata