Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This worked really well for me, thanks. I did remove the keepchar function though, I'm not sure how it would help me.
I didn't know if your data included minutes or not (0.73 vs 0.73 minutes)