6 Replies Latest reply: Jan 28, 2015 9:39 AM by Marco Wedel RSS

    int to hh:mm:ss

    Ashish Sharma


      Hi,


      I am converting seconds into hh:mm:ss like


      = Interval(Interval#(SUM (Value),'ss'),'hh:mm:ss')

       

      Conversion is working fine but if value is big number it is coming in -ve.
      Why it is coming -ve value? Please help/suggest some better solution.


      Test:

      Load * inline [
      id,Value
      1,1000,
      2,25500000,
      3,4556800000,
      4,6767676767,
      5,6767676767,

      ];