12 Replies Latest reply: Apr 20, 2017 7:18 AM by Sunny Talwar RSS

    Format seconds to [hh]:mm:ss

    Matt Wilson

      Hi guys please can someone tell me how to format a field in time so over 24 hours clocks up the hours if that make sense so hh:mm:ss 25:00:00 should not equal 01:00:00

      this is currently the expression that I have tried

      Interval(SUM(TalkTime)/86400, 'hh:mm:ss')

       

      Thanks so much

       

      Matt