3 Replies Latest reply on Mar 8, 2018 2:17 PM by Andrew Bickert

    How to convert number of seconds to format mm:ss

    Kelly C

      Hi Everyone,

       

      I've been trying to reformat my number from seconds to mm:ss, but when i custom format the number to mm:ss, the 90 seconds turns into 00:00.  My goal outcome would be for it to look like 1:30 instead of 90 seconds.  I'm wondering if the issue has to do with my initial calculation for ASA....

       

      Please see attached workbook. 

       

      Thanks so much!!