calculate the Average Turn around time

building reports desktopintelligence
1

Hi All,

I have a object to calculate the turn arround time (TAT). i am getting values of TAT as 1d 4h 45 min ;2d 2h 5m ; 0d 19h 40 m

can you help me calculation the average of these three values (TAT).

thanks
habib

’

rubina (BOB member since 2006-09-17)

2

If you are doing this at the Universe level with an object then Convert your times to minutes and Sum. Then divide by the number of non zero figures e.g. Count(FactID) . This will give you the average in minutes.

adrianhayman :uk: (BOB member since 2005-02-14)