11 Replies Latest reply: Jan 27, 2017 9:59 AM by Sunny Talwar RSS

    Convert/Format Decimal to Appropriate Time

    Jeremy Schmitt

      So I have found pieces of this discussion, but have not received a solution trying to put them all together.

       

      I have data where the field is represented in minutes and then divided by another field to get an Average Handle Time of a call. I get results where the average is .73 minutes, 10.6 minutes, and 85 minutes as examples. I need these minutes broken out into proper Hours, Minutes, and Seconds.

       

      So far I have tried some Time formatting and taking the results *60, but cannot solve formatting the final results to hh:mm:ss successfully. What am I doing wrong? I am assuming it's easiest to do this right away in the script?