9 Replies Latest reply: Sep 24, 2018 11:53 AM by Vipul Narang RSS

    Converting seconds to 'hh:mm:ss' format is not working properly

    Vipul Narang

      Hello,

       

      I am using an extension object "climber KPI version 1.5.0"

       

      By using that, i am showing a metric versus a benchmark. For example, Time on site is in seconds and by using the following formula , i for the metric and benchmark i get the output as the image attached (TimeOnSite)

       

      =(Time(($(vBenchmarkTimeOnSite))/(3600*24),'hh:mm:ss'))

       

      Which is how it should work.

       

      But when i use the same for a different metric with similar calculation and numbers, the result comes out to be less than 1 minute (which is correct) but then the difference it is showing with relation to the benchmark is different (check image - TimeOnPage)

       

      Can anybody please help me resolve this issue?

       

      Thanks!

      VN