7 Replies Latest reply on Jul 13, 2017 10:33 PM by Hari Ankem

    How to convert seconds into MM:SS Format

    tejaswi.jaddu

      Hi All,

      I have data in seconds on which i have to do AVG and show in MM:SS format. I used below formula to create a calculated field

      1) Formula : Seconds is the column which has data in seconds

      IIF([Seconds] % 60 == 60,0,[Seconds] % 60)

      + INT([Seconds]/60) * 100

      2) On top of calculated field , i have applied AVG function and custom Format to 00:00 which gives me output as 05:90, but i should supposed to get as 06:30.

       

      • How i converted data into seconds is (EndDate- StartDate)*86400= seconds column

       

       

      Can someone help me guide, where i am doing wrong calculation or format

       

       

      Thanks,

      Teja