Difference between two times and average of all results. 1

[laina222]

I have two fields, both time fields, formatted as HH:MM:SS. I need to calculate the difference between the two times, or time between.
For example:
Field 1: 08:30:30
Field 2: 11:45:40
Expected result: 03:15:10
And then I'd like to get an average of all of these time differences.
I'm using Business Objects v. 5.1.6
Thanks for any help in advance!

 

[laina222]

Also, there could be several days between the two times, so the date fields that correspond need to be considered.

 

[skrandel]

Unfortunately, you'll have to do this all at the universe level. You'll have to take any dates and convert them to numbers of seconds.

The real issue is that the BO Reporting tool has no ability to do math on times.

Steve Krandel
VERITAS Software