9 Replies Latest reply: Mar 21, 2011 4:40 PM by Oleg Troyansky RSS

    time calculations within a straight table

    Brandon Vann

      I dont understand why I'm struggling with this so much but I'm using phone data, in the form of (hh:mm:ss), and I need to do a very simple calculation, average, for each month. I need average ring time/call time/hold time etc.

      Everything that I have tried so far just returns a null or gives me "00:00:00". Even when I try to start simple with, sum(ringtime).

      Can anyone help me?