jayankurian

Calculate Average Time based on condition

Discussion created by jayankurian on Dec 6, 2017
Latest reply on Dec 8, 2017 by jayankurian

Hi all....

I have two tables

One table have one field which is Date

Second table 6 fields (includes two timestamp fields)  and two calculation fields. (table been related thru Date)

                   TimeStamp Fields:                                       CalcField:

StartDateTime:                   End DateTime                  TurnAroundTime

12/2/2017 10:20 AM          12/2/2017 11:15 AM                 0:55

12/3/2017 11:00 PM          12/4/2017 07:00 AM                 8:00

12/2/2017 14:20 PM          12/2/2017 16:15 PM                 1:55

12/5/2017 9:20 AM            12/5/2017 14:20 AM                  5:00

12/6/2017 11:20 AM          12/6/2017 15:15 PM                  4:55

12/2/2017 6:20 PM            12/2/2017 8:15 PM                    1:55     

 

Looking for an average of the TAT which is less than or equal to 2 Hours

 

To accomplish that I created two calculation fields.

This calculation worked for me for a while and all of a sudden I am getting wrong averages as I add more data into the DB.

 

I am sure there is some better calculation out there that can  give me the expected output.

Appreciate any help that lead me to the direct direction.

 

Thank you.....

Outcomes