Difference between two times and average of all

[laina222]

I have two fields that are both time fields. They are formatted as HH:MM:SS AM/PM.
I need to be able to calculate the time between both fields, so for example:
Time1: 8:30:30 AM
Time2: 11:45:40 AM
Expected result: 3:15:10
Then after I get all my time differences for all rows, I need to get an average of the times.
Thanks for any help in advance!

 

[lespaul]

are all the differences less than 24 hours?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[laina222]

Actually no, I just came back to post an addendum. There could be several days between the two dates. Good point!